ERPstuff - Oracle EBS Community

How can i do such topic
i tried all option but it didnot work corrctly
please if any one has solution

If the deductions are more than earnings you need this
when emp want to pay his loan in advance in separate quickpay(for ex)

QUERY THE ELEMENT LINK BY ELEMENT NAME AND MAKE SURE YOU Eligibility Criteria IS NOT THERE

you can add this condition

if LOCATION_CODE=? Plant? and D_MARTIAL_STATUS=?Married?
then
deduction = greatest(monthly_housing_allowance_housing,monthly_housing_rent)/*use your data base items*/

select F.EMPLOYEE_NUMBER"FILE NUMBER",initcap(F.FULL_NAME)"NAME",TO_CHAR (F.ORIGINAL_DATE_OF_HIRE,'DD/MM/YYYY')"Hire Date",
t.name"DEPARTMENT",l.MEANING"Nationality",
p.segment1||p.segment2"COST CENTER",S.NAME"POSITION",ASSIGNMENT_STATUS_TYPE_ID"STATUS",
F.DATE_OF_BIRTH "BIRTH DATE"---,E.PEI ...

Any one have another api for updating assignment status
can send to me
abbasmalek@hotmail.com

Dear skm
i changed the cursor to this

select a.assignment_number,
a.effective_start_date,
a.assignment_id,
a.object_version_number,
a.soft_coding_keyflex_id,
t. assignment_status_type_id,
a.cagr_grade_def_id,
a.assignment_status_type_id OLD,
s.assignment_status_type_id type


from ASS_STATUS ...

This is the error

Dear all
can any one help me to update Assignment Status
i used this code but always find error
declare
-- Boolean parameters are translated from/to integers:
-- 0/1/null <--> false/true/null
----p_validate boolean := sys.diutil.int_to_bool(:p_validate);
p_no_managers_warning boolean;
p ...

Dear forever
if he absent 31 days in october ie from 1st to 31
and you run on 26
if the absent already entered then he will get no salary
if some days enter after run you can handle it with retro pay
process

Dear alruwaished
as i told befor i am using the same for salary or any other element
change during the period

<font size="3">Dear Kasi, Vijayakumar
thank you vey much for your help
i will try these queries
thanks again</font id="size3">

Dear all

Can any one provide a query to extract this information
Responsibility name
menus and functions available with Responsibility
users assigned to that Responsibility
position of users
Responsibility start date
THANKS

Dear Mr Alrowashid
i am using this method for all purposes that you mentioned and more and it is working properly

Dear Alruwaished,

You can Also handle Proration alone in the fast formula.. there is absolutly no need to create any custom pakages. If you need tell me i wil mail you the entire solution for payroll in approx 5lines in the FF
Dear sayed.najafali
can you please send it here
abbasmalek@hotmail.com ...