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_DSRR_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 697: FROM pay_payroll_actions

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

Line 755: , pay_payroll_actions ppa

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

Line 789: , pay_payroll_actions ppa

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

Line 846: , pay_payroll_actions ppa

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

Line 895: , pay_payroll_actions ppa

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

Line 936: , pay_payroll_actions ppa

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

Line 999: , pay_payroll_actions ppa

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

Line 1362: FROM pay_payroll_actions ppa

1358: /**************************************************************************/
1359: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1360: SELECT ppa.payroll_action_id
1361: ,paa.chunk_number
1362: FROM pay_payroll_actions ppa
1363: ,pay_assignment_actions paa
1364: WHERE paa.payroll_action_id = ppa.payroll_action_id
1365: AND paa.assignment_action_id = c_assignment_action_id;
1366: /**************************************************************************/

Line 1371: , pay_payroll_actions ppa

1367: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1368: SELECT paa.assignment_id
1369: , paa.chunk_number
1370: FROM pay_assignment_actions paa
1371: , pay_payroll_actions ppa
1372: WHERE paa.payroll_action_id = ppa.payroll_action_id
1373: AND paa.assignment_action_id = c_assignment_action_id;
1374: /**************************************************************************/
1375: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS

Line 2001: FROM pay_payroll_actions ppa

1997: WHERE locking_action_id = c_assignment_action_id;
1998: /**************************************************************************/
1999: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2000: SELECT ppa.payroll_action_id
2001: FROM pay_payroll_actions ppa
2002: ,pay_assignment_actions paa
2003: WHERE paa.payroll_action_id = ppa.payroll_action_id
2004: AND paa.assignment_action_id = c_assignment_action_id;
2005: /**************************************************************************/