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_LTSR_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 282: FROM pay_payroll_actions

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

Line 650: ,pay_payroll_actions ppa

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

Line 695: FROM pay_payroll_actions

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

Line 752: ,pay_payroll_actions ppa

748: SELECT DISTINCT
749: paa.assignment_id assignment_id
750: FROM per_absence_attendance_types paat
751: ,per_absence_attendances pab
752: ,pay_payroll_actions ppa
753: ,per_all_assignments_f paa
754: ,per_all_people_f pap
755: WHERE paat.absence_category = 'S'
756: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id

Line 785: ,pay_payroll_actions ppa

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

Line 841: ,pay_payroll_actions ppa

837: FROM per_absence_attendance_types paat
838: ,per_absence_attendances pab
839: ,per_all_assignments_f paa
840: ,per_all_people_f pap
841: ,pay_payroll_actions ppa
842: ,per_org_structure_versions posv
843: WHERE posv.organization_structure_id = p_org_struct_id
844: AND pap.person_id BETWEEN p_start_person_id
845: 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_LTSR_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 1333: FROM pay_payroll_actions ppa

1329: /**************************************************************************/
1330: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1331: SELECT ppa.payroll_action_id
1332: ,paa.chunk_number
1333: FROM pay_payroll_actions ppa
1334: ,pay_assignment_actions paa
1335: WHERE paa.payroll_action_id = ppa.payroll_action_id
1336: AND paa.assignment_action_id = c_assignment_action_id;
1337: /**************************************************************************/

Line 1342: ,pay_payroll_actions ppa

1338: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1339: SELECT paa.assignment_id
1340: ,paa.chunk_number
1341: FROM pay_assignment_actions paa
1342: ,pay_payroll_actions ppa
1343: WHERE paa.payroll_action_id = ppa.payroll_action_id
1344: AND paa.assignment_action_id = c_assignment_action_id;
1345: /**************************************************************************/
1346: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS

Line 1940: FROM pay_payroll_actions ppa

1936: WHERE locking_action_id = c_assignment_action_id;
1937: /**************************************************************************/
1938: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1939: SELECT ppa.payroll_action_id
1940: FROM pay_payroll_actions ppa
1941: ,pay_assignment_actions paa
1942: WHERE paa.payroll_action_id = ppa.payroll_action_id
1943: AND paa.assignment_action_id = c_assignment_action_id;
1944: /**************************************************************************/