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_ASSIGNMENT_ACTIONS

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

1054: ,p_chunk IN NUMBER)
1055: IS
1056: l_asg_act_id NUMBER;
1057: BEGIN
1058: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1059: hr_nonrun_asact.insact(
1060: lockingactid => l_asg_act_id
1061: ,assignid => p_assignid
1062: ,pactid => p_pactid

Line 1212: , pay_assignment_actions paa

1208: , pab.abs_information7 tel_no
1209: , pab.abs_information_category info_cat
1210: FROM per_absence_attendance_types paat
1211: , per_absence_attendances pab
1212: , pay_assignment_actions paa
1213: , per_all_assignments_f pas
1214: WHERE paat.absence_category = 'S'
1215: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1216: AND paat.business_group_id = pab.business_group_id

Line 1334: ,pay_assignment_actions paa

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

Line 1341: FROM pay_assignment_actions paa

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

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

1418: IF l_exists = 'Y' THEN
1419: fnd_file.put_line(fnd_file.log,'Long Term Sickness Report already sent. Hence skipped.');
1420: ELSIF l_exists = 'N' THEN
1421:
1422: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1423:
1424: hr_nonrun_asact.insact(
1425: lockingactid => l_child_aa_id
1426: , assignid => l_assignment_id

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

1689: /**************************************************************************/
1690: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS
1691:
1692:
1693: CURSOR cur_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1694: SELECT pai.action_information1 abs_att_id
1695: ,pai.action_information2 start_date
1696: ,pai.action_information3 end_date
1697: ,pai.action_information4 abs_cat

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

1708: WHERE pai.action_context_id = c_assignment_action_id
1709: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1710: AND action_context_type = 'AAP';
1711: /**************************************************************************/
1712: CURSOR cur_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1713: SELECT action_information2 test_msg
1714: ,action_information3 tax_no_sender
1715: ,action_information4 role_sender
1716: ,action_information5 contact_per_or_dept

Line 1737: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is

1733: AND pai.action_information_category = 'NL_LTSR_EMP_INFO'
1734: AND action_context_type = 'AAP';
1735:
1736: /**************************************************************************/
1737: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
1738: SELECT pai.action_information30 flag
1739: FROM pay_action_information pai
1740: WHERE pai.action_context_id = c_assignment_action_id
1741: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'

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

1924: l_start_date DATE := NULL;
1925: l_end_date DATE := NULL;
1926: l_type VARCHAR2(1) := NULL;
1927: /**************************************************************************/
1928: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1929: SELECT assignment_action_id ass_act_id
1930: FROM pay_assignment_actions
1931: WHERE source_action_id = c_assignment_action_id;
1932: /**************************************************************************/

Line 1930: FROM pay_assignment_actions

1926: l_type VARCHAR2(1) := NULL;
1927: /**************************************************************************/
1928: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1929: SELECT assignment_action_id ass_act_id
1930: FROM pay_assignment_actions
1931: WHERE source_action_id = c_assignment_action_id;
1932: /**************************************************************************/
1933: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1934: SELECT locked_action_id parent_id

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

1929: SELECT assignment_action_id ass_act_id
1930: FROM pay_assignment_actions
1931: WHERE source_action_id = c_assignment_action_id;
1932: /**************************************************************************/
1933: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1934: SELECT locked_action_id parent_id
1935: FROM pay_action_interlocks
1936: WHERE locking_action_id = c_assignment_action_id;
1937: /**************************************************************************/

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

1934: SELECT locked_action_id parent_id
1935: FROM pay_action_interlocks
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

Line 1941: ,pay_assignment_actions paa

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