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.PER_NL_LTSRR_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 223: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

219: ,p_token IN VARCHAR2
220: ,p_segment_number IN NUMBER DEFAULT NULL )
221: RETURN VARCHAR2 IS
222:
223: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
224: l_start_pos NUMBER;
225: l_delimiter varchar2(1):=' ';
226:
227: BEGIN

Line 281: FROM pay_payroll_actions

277: ,business_group_id bg_id
278: ,start_date start_date
279: ,effective_date end_date
280: ,get_parameter(legislative_parameters,'TYPE') report_type
281: FROM pay_payroll_actions
282: WHERE payroll_action_id = p_payroll_action_id;
283:
284: l_param csr_parameter_info%ROWTYPE;
285:

Line 651: ,pay_payroll_actions ppa

647: BEGIN
648: hr_utility.trace('+====range_code============================================+');
649: sqlstr := 'SELECT DISTINCT person_id
650: FROM per_all_people_f pap
651: ,pay_payroll_actions ppa
652: WHERE ppa.payroll_action_id = :payroll_action_id
653: AND ppa.business_group_id = pap.business_group_id
654: ORDER BY pap.person_id';
655: hr_utility.trace('X====range_code============================================X');

Line 699: FROM pay_payroll_actions

695: /**************************************************************************/
696: CURSOR c_bg_stdate(p_payroll_action_id IN NUMBER) IS
697: SELECT business_group_id bg_id
698: ,start_date start_date
699: FROM pay_payroll_actions
700: WHERE payroll_action_id = p_payroll_action_id;
701: /**************************************************************************/
702: l_user_table_id NUMBER;
703: l_user_column_id NUMBER;

Line 757: , pay_payroll_actions ppa

753: paa.assignment_id assignment_id
754: , pab.absence_attendance_id abs_att_id
755: FROM per_absence_attendance_types paat
756: , per_absence_attendances pab
757: , pay_payroll_actions ppa
758: , per_all_assignments_f paa
759: , per_all_people_f pap
760: WHERE paat.absence_category = 'S'
761: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id

Line 791: , pay_payroll_actions ppa

787: paa.assignment_id assignment_id
788: , pab.absence_attendance_id abs_att_id
789: FROM per_absence_attendance_types paat
790: , per_absence_attendances pab
791: , pay_payroll_actions ppa
792: , per_org_structure_versions posv
793: , per_all_assignments_f paa
794: , per_all_people_f pap
795: WHERE posv.organization_structure_id = p_org_struct_id

Line 848: , pay_payroll_actions ppa

844: FROM per_absence_attendance_types paat
845: , per_absence_attendances pab
846: , per_all_assignments_f paa
847: , per_all_people_f pap
848: , pay_payroll_actions ppa
849: , per_org_structure_versions posv
850: WHERE posv.organization_structure_id = p_org_struct_id
851: AND pap.person_id BETWEEN p_start_person_id
852: AND p_end_person_id

Line 898: , pay_payroll_actions ppa

894: ,p_type IN VARCHAR2) IS
895: SELECT DISTINCT
896: paa.assignment_id assignment_id
897: FROM pay_action_information pai
898: , pay_payroll_actions ppa
899: , per_all_assignments_f paa
900: , per_all_people_f pap
901: WHERE pai.action_context_type = 'AAP'
902: AND pai.action_information_category = 'NL_LTSRR_ABS_INFO'

Line 939: , pay_payroll_actions ppa

935: ,p_type IN VARCHAR2) IS
936: SELECT DISTINCT
937: paa.assignment_id assignment_id
938: FROM pay_action_information pai
939: , pay_payroll_actions ppa
940: , per_org_structure_versions posv
941: , per_all_assignments_f paa
942: , per_all_people_f pap
943: WHERE posv.organization_structure_id = p_org_struct_id

Line 1002: , pay_payroll_actions ppa

998: paa.assignment_id assignment_id
999: FROM pay_action_information pai
1000: , per_all_assignments_f paa
1001: , per_all_people_f pap
1002: , pay_payroll_actions ppa
1003: , per_org_structure_versions posv
1004: WHERE posv.organization_structure_id = p_org_struct_id
1005: AND pap.person_id BETWEEN p_start_person_id
1006: AND p_end_person_id

Line 1373: FROM pay_payroll_actions ppa

1369: /**************************************************************************/
1370: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1371: SELECT ppa.payroll_action_id
1372: ,paa.chunk_number
1373: FROM pay_payroll_actions ppa
1374: ,pay_assignment_actions paa
1375: WHERE paa.payroll_action_id = ppa.payroll_action_id
1376: AND paa.assignment_action_id = c_assignment_action_id;
1377: /**************************************************************************/

Line 1382: , pay_payroll_actions ppa

1378: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1379: SELECT paa.assignment_id
1380: , paa.chunk_number
1381: FROM pay_assignment_actions paa
1382: , pay_payroll_actions ppa
1383: WHERE paa.payroll_action_id = ppa.payroll_action_id
1384: AND paa.assignment_action_id = c_assignment_action_id;
1385: /**************************************************************************/
1386: CURSOR csr_get_assignment_dates(p_assignment_id IN NUMBER) IS

Line 2027: FROM pay_payroll_actions ppa

2023: WHERE locking_action_id = c_assignment_action_id;
2024: /**************************************************************************/
2025: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2026: SELECT ppa.payroll_action_id
2027: FROM pay_payroll_actions ppa
2028: ,pay_assignment_actions paa
2029: WHERE paa.payroll_action_id = ppa.payroll_action_id
2030: AND paa.assignment_action_id = c_assignment_action_id;
2031: /**************************************************************************/