APPS.PER_NL_WAZO_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 284: FROM pay_payroll_actions

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

Line 652: ,pay_payroll_actions ppa

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

Line 698: FROM pay_payroll_actions

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

Line 755: ,pay_payroll_actions ppa

751: SELECT DISTINCT
752: paa.assignment_id assignment_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 = 'WAZO'
759: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id

Line 787: ,pay_payroll_actions ppa

783: SELECT DISTINCT
784: paa.assignment_id assignment_id
785: FROM per_absence_attendance_types paat
786: ,per_absence_attendances pab
787: ,pay_payroll_actions ppa
788: ,per_org_structure_versions posv
789: ,per_all_assignments_f paa
790: ,per_all_people_f pap
791: WHERE posv.organization_structure_id = p_org_struct_id

Line 842: ,pay_payroll_actions ppa

838: FROM per_absence_attendance_types paat
839: ,per_absence_attendances pab
840: ,per_all_assignments_f paa
841: ,per_all_people_f pap
842: ,pay_payroll_actions ppa
843: ,per_org_structure_versions posv
844: WHERE posv.organization_structure_id = p_org_struct_id
845: AND pap.person_id BETWEEN p_start_person_id
846: AND p_end_person_id

Line 890: ,pay_payroll_actions ppa

886: ,p_type IN VARCHAR2) IS
887: SELECT DISTINCT
888: paa.assignment_id assignment_id
889: FROM pay_action_information pai
890: ,pay_payroll_actions ppa
891: ,per_all_assignments_f paa
892: ,per_all_people_f pap
893: WHERE pai.action_context_type = 'AAP'
894: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'

Line 931: ,pay_payroll_actions ppa

927: ,p_type IN VARCHAR2) IS
928: SELECT DISTINCT
929: paa.assignment_id assignment_id
930: FROM pay_action_information pai
931: ,pay_payroll_actions ppa
932: ,per_org_structure_versions posv
933: ,per_all_assignments_f paa
934: ,per_all_people_f pap
935: WHERE posv.organization_structure_id = p_org_struct_id

Line 994: ,pay_payroll_actions ppa

990: paa.assignment_id assignment_id
991: FROM pay_action_information pai
992: ,per_all_assignments_f paa
993: ,per_all_people_f pap
994: ,pay_payroll_actions ppa
995: ,per_org_structure_versions posv
996: WHERE posv.organization_structure_id = p_org_struct_id
997: AND pap.person_id BETWEEN p_start_person_id
998: AND p_end_person_id

Line 1476: FROM pay_payroll_actions ppa

1472: /**************************************************************************/
1473: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1474: SELECT ppa.payroll_action_id
1475: ,paa.chunk_number
1476: FROM pay_payroll_actions ppa
1477: ,pay_assignment_actions paa
1478: WHERE paa.payroll_action_id = ppa.payroll_action_id
1479: AND paa.assignment_action_id = c_assignment_action_id;
1480: /**************************************************************************/

Line 1485: ,pay_payroll_actions ppa

1481: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1482: SELECT paa.assignment_id
1483: ,paa.chunk_number
1484: FROM pay_assignment_actions paa
1485: ,pay_payroll_actions ppa
1486: WHERE paa.payroll_action_id = ppa.payroll_action_id
1487: AND paa.assignment_action_id = c_assignment_action_id;
1488: /**************************************************************************/
1489: CURSOR csr_get_assignment_dates(p_assignment_id IN NUMBER) IS

Line 2397: FROM pay_payroll_actions ppa

2393: WHERE locking_action_id = c_assignment_action_id;
2394: /**************************************************************************/
2395: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2396: SELECT ppa.payroll_action_id
2397: FROM pay_payroll_actions ppa
2398: ,pay_assignment_actions paa
2399: WHERE paa.payroll_action_id = ppa.payroll_action_id
2400: AND paa.assignment_action_id = c_assignment_action_id;
2401: /**************************************************************************/