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_ASSIGNMENT_ACTIONS

Line 1064: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;

1060: ,p_chunk IN NUMBER)
1061: IS
1062: l_asg_act_id NUMBER;
1063: BEGIN
1064: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1065: hr_nonrun_asact.insact(
1066: lockingactid => l_asg_act_id
1067: ,assignid => p_assignid
1068: ,pactid => p_pactid

Line 1219: , pay_assignment_actions paa

1215: , to_char ((pab.date_end + 1), 'YYYYMMDD') lts_rec_dt
1216: , pab.abs_information_category info_cat
1217: FROM per_absence_attendance_types paat
1218: , per_absence_attendances pab
1219: , pay_assignment_actions paa
1220: , per_all_assignments_f pas
1221: WHERE paat.absence_category = 'S'
1222: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1223: AND paat.business_group_id = pab.business_group_id

Line 1374: ,pay_assignment_actions paa

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: /**************************************************************************/
1378: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS

Line 1381: FROM pay_assignment_actions paa

1377: /**************************************************************************/
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: /**************************************************************************/

Line 1482: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;

1478: IF l_LTSR_exists = 'N' THEN
1479: fnd_file.put_line(fnd_file.log,'Long Term Sickness Report not sent. Hence skipped.');
1480: ELSIF l_LTSR_exists = 'Y' THEN
1481:
1482: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1483: hr_nonrun_asact.insact(
1484: lockingactid => l_child_aa_id
1485: , assignid => l_assignment_id
1486: , pactid => l_payroll_action_id

Line 1762: CURSOR cur_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

1758:
1759:
1760: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS
1761:
1762: CURSOR cur_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1763: SELECT pai.action_information1 abs_att_id
1764: ,pai.action_information2 start_date
1765: ,pai.action_information3 end_date
1766: ,pai.action_information4 abs_cat

Line 1781: CURSOR cur_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

1777: WHERE pai.action_context_id = c_assignment_action_id
1778: AND pai.action_information_category = 'NL_LTSRR_ABS_INFO'
1779: AND action_context_type = 'AAP';
1780: /**************************************************************************/
1781: CURSOR cur_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1782: SELECT action_information2 test_msg
1783: ,action_information3 tax_no_sender
1784: ,action_information4 role_sender
1785: ,action_information5 contact_per_or_dept

Line 1810: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

1806: WHERE pai.action_context_id = c_assignment_action_id
1807: AND pai.action_information_category = 'NL_LTSRR_EMP_INFO'
1808: AND action_context_type = 'AAP';
1809: /**************************************************************************/
1810: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1811: SELECT pai.action_information30 flag
1812: FROM pay_action_information pai
1813: WHERE pai.action_context_id = c_assignment_action_id
1814: AND pai.action_information_category = 'NL_LTSRR_ABS_INFO'

Line 2015: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

2011: l_start_date DATE := NULL;
2012: l_end_date DATE := NULL;
2013: l_type VARCHAR2(1) := NULL;
2014: /**************************************************************************/
2015: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2016: SELECT assignment_action_id ass_act_id
2017: FROM pay_assignment_actions
2018: WHERE source_action_id = c_assignment_action_id;
2019: /**************************************************************************/

Line 2017: FROM pay_assignment_actions

2013: l_type VARCHAR2(1) := NULL;
2014: /**************************************************************************/
2015: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2016: SELECT assignment_action_id ass_act_id
2017: FROM pay_assignment_actions
2018: WHERE source_action_id = c_assignment_action_id;
2019: /**************************************************************************/
2020: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2021: SELECT locked_action_id parent_id

Line 2020: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

2016: SELECT assignment_action_id ass_act_id
2017: FROM pay_assignment_actions
2018: WHERE source_action_id = c_assignment_action_id;
2019: /**************************************************************************/
2020: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2021: SELECT locked_action_id parent_id
2022: FROM pay_action_interlocks
2023: WHERE locking_action_id = c_assignment_action_id;
2024: /**************************************************************************/

Line 2025: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

2021: SELECT locked_action_id parent_id
2022: FROM pay_action_interlocks
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

Line 2028: ,pay_assignment_actions paa

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: /**************************************************************************/
2032: