eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 482: FROM pay_Assignment_actions WHERE

478: CURSOR csr_assignment_action (csr_v_payroll_action_id
479: pay_payroll_actions.payroll_action_id%type)
480: IS
481: SELECT MAX(assignment_action_id)
482: FROM pay_Assignment_actions WHERE
483: payroll_action_id=csr_v_payroll_action_id; --23
484:
485: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
486: hr_organization_units.organization_id%TYPE)

Line 553: l_assignment_id pay_Assignment_actions.assignment_id%type;

549: l_end_date date;
550: l_termination_date date;
551: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
552: l_value number;
553: l_assignment_id pay_Assignment_actions.assignment_id%type;
554: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
555: L_CFAR_NUMBER NUMBER;
556: l_legal_employer_id NUMBER;
557: l_virtual_date DATE;

Line 554: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;

550: l_termination_date date;
551: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
552: l_value number;
553: l_assignment_id pay_Assignment_actions.assignment_id%type;
554: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
555: L_CFAR_NUMBER NUMBER;
556: l_legal_employer_id NUMBER;
557: l_virtual_date DATE;
558: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;

Line 1019: FROM pay_Assignment_actions WHERE

1015: CURSOR csr_assignment_action (csr_v_payroll_action_id
1016: pay_payroll_actions.payroll_action_id%type)
1017: IS
1018: SELECT MAX(assignment_action_id)
1019: FROM pay_Assignment_actions WHERE
1020: payroll_action_id=csr_v_payroll_action_id; --23
1021:
1022: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
1023: hr_organization_units.organization_id%TYPE)

Line 1064: FROM pay_assignment_actions paa,

1060: CURSOR csr_element_types(csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date,
1061: csr_v_element_type_id number, csr_v_input_value_id number)
1062: IS
1063: SELECT SUM(RESULT_VALUE) total --prrv1.* ,paa.assignment_id
1064: FROM pay_assignment_actions paa,
1065: pay_payroll_actions ppa,
1066: pay_run_results prr,
1067: pay_run_result_values prrv1,
1068: pay_input_values_f pivf,

Line 1177: l_assignment_id pay_Assignment_actions.assignment_id%type;

1173: --l_end_date date;
1174: l_termination_date date;
1175: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
1176: l_value number;
1177: l_assignment_id pay_Assignment_actions.assignment_id%type;
1178: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
1179: L_CFAR_NUMBER NUMBER;
1180: l_legal_employer_id NUMBER;
1181: l_virtual_date DATE;

Line 1178: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;

1174: l_termination_date date;
1175: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
1176: l_value number;
1177: l_assignment_id pay_Assignment_actions.assignment_id%type;
1178: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
1179: L_CFAR_NUMBER NUMBER;
1180: l_legal_employer_id NUMBER;
1181: l_virtual_date DATE;
1182: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;