APPS.PER_NL_DSR_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 283: FROM pay_payroll_actions

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

Line 784: ,pay_payroll_actions ppa

780: BEGIN
781: hr_utility.trace('+====range_code============================================+');
782: sqlstr := 'SELECT DISTINCT person_id
783: FROM per_all_people_f pap
784: ,pay_payroll_actions ppa
785: WHERE ppa.payroll_action_id = :payroll_action_id
786: AND ppa.business_group_id = pap.business_group_id
787: ORDER BY pap.person_id';
788: hr_utility.trace('X====range_code============================================X');

Line 830: FROM pay_payroll_actions

826: /**************************************************************************/
827: CURSOR c_bg_stdate(p_payroll_action_id IN NUMBER) IS
828: SELECT business_group_id bg_id
829: ,start_date start_date
830: FROM pay_payroll_actions
831: WHERE payroll_action_id = p_payroll_action_id;
832: /**************************************************************************/
833: l_user_table_id NUMBER;
834: l_user_column_id NUMBER;

Line 887: ,pay_payroll_actions ppa

883: SELECT DISTINCT
884: paa.assignment_id assignment_id
885: FROM per_absence_attendance_types paat
886: ,per_absence_attendances pab
887: ,pay_payroll_actions ppa
888: ,per_all_assignments_f paa
889: ,per_all_people_f pap
890: WHERE paat.absence_category = 'S'
891: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id

Line 920: ,pay_payroll_actions ppa

916: SELECT DISTINCT
917: paa.assignment_id assignment_id
918: FROM per_absence_attendance_types paat
919: ,per_absence_attendances pab
920: ,pay_payroll_actions ppa
921: ,per_org_structure_versions posv
922: ,per_all_assignments_f paa
923: ,per_all_people_f pap
924: WHERE posv.organization_structure_id = p_org_struct_id

Line 976: ,pay_payroll_actions ppa

972: FROM per_absence_attendance_types paat
973: ,per_absence_attendances pab
974: ,per_all_assignments_f paa
975: ,per_all_people_f pap
976: ,pay_payroll_actions ppa
977: ,per_org_structure_versions posv
978: WHERE posv.organization_structure_id = p_org_struct_id
979: AND pap.person_id BETWEEN p_start_person_id
980: AND p_end_person_id

Line 1025: ,pay_payroll_actions ppa

1021: ,p_type IN VARCHAR2) IS
1022: SELECT DISTINCT
1023: paa.assignment_id assignment_id
1024: FROM pay_action_information pai
1025: ,pay_payroll_actions ppa
1026: ,per_all_assignments_f paa
1027: ,per_all_people_f pap
1028: WHERE pai.action_context_type = 'AAP'
1029: AND pai.action_information_category = 'NL_DSR_ABS_INFO'

Line 1066: ,pay_payroll_actions ppa

1062: ,p_type IN VARCHAR2) IS
1063: SELECT DISTINCT
1064: paa.assignment_id assignment_id
1065: FROM pay_action_information pai
1066: ,pay_payroll_actions ppa
1067: ,per_org_structure_versions posv
1068: ,per_all_assignments_f paa
1069: ,per_all_people_f pap
1070: WHERE posv.organization_structure_id = p_org_struct_id

Line 1129: ,pay_payroll_actions ppa

1125: paa.assignment_id assignment_id
1126: FROM pay_action_information pai
1127: ,per_all_assignments_f paa
1128: ,per_all_people_f pap
1129: ,pay_payroll_actions ppa
1130: ,per_org_structure_versions posv
1131: WHERE posv.organization_structure_id = p_org_struct_id
1132: AND pap.person_id BETWEEN p_start_person_id
1133: AND p_end_person_id

Line 1712: FROM pay_payroll_actions ppa

1708: /**************************************************************************/
1709: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1710: SELECT ppa.payroll_action_id
1711: ,paa.chunk_number
1712: FROM pay_payroll_actions ppa
1713: ,pay_assignment_actions paa
1714: WHERE paa.payroll_action_id = ppa.payroll_action_id
1715: AND paa.assignment_action_id = c_assignment_action_id;
1716: /**************************************************************************/

Line 1721: ,pay_payroll_actions ppa

1717: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1718: SELECT paa.assignment_id
1719: ,paa.chunk_number
1720: FROM pay_assignment_actions paa
1721: ,pay_payroll_actions ppa
1722: WHERE paa.payroll_action_id = ppa.payroll_action_id
1723: AND paa.assignment_action_id = c_assignment_action_id;
1724: /**************************************************************************/
1725: CURSOR csr_get_assignment_dates(p_assignment_id IN NUMBER) IS

Line 2993: FROM pay_payroll_actions ppa

2989: WHERE locking_action_id = c_assignment_action_id;
2990: /**************************************************************************/
2991: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2992: SELECT ppa.payroll_action_id
2993: FROM pay_payroll_actions ppa
2994: ,pay_assignment_actions paa
2995: WHERE paa.payroll_action_id = ppa.payroll_action_id
2996: AND paa.assignment_action_id = c_assignment_action_id;
2997: /**************************************************************************/