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_DSRR_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

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

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

Line 1224: ,pay_assignment_actions paa

1220: ,'YYYYMMDD') partial_rec_dt
1221: ,pab.abs_information13 daily_si
1222: FROM per_absence_attendance_types paat
1223: ,per_absence_attendances pab
1224: ,pay_assignment_actions paa
1225: ,per_all_assignments_f pas
1226: WHERE paat.absence_category = 'S'
1227: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1228: AND paat.business_group_id = pab.business_group_id

Line 1363: ,pay_assignment_actions paa

1359: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1360: SELECT ppa.payroll_action_id
1361: ,paa.chunk_number
1362: FROM pay_payroll_actions ppa
1363: ,pay_assignment_actions paa
1364: WHERE paa.payroll_action_id = ppa.payroll_action_id
1365: AND paa.assignment_action_id = c_assignment_action_id;
1366: /**************************************************************************/
1367: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS

Line 1370: FROM pay_assignment_actions paa

1366: /**************************************************************************/
1367: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1368: SELECT paa.assignment_id
1369: , paa.chunk_number
1370: FROM pay_assignment_actions paa
1371: , pay_payroll_actions ppa
1372: WHERE paa.payroll_action_id = ppa.payroll_action_id
1373: AND paa.assignment_action_id = c_assignment_action_id;
1374: /**************************************************************************/

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

1459: IF l_SR_exists = 'N' THEN
1460: fnd_file.put_line(fnd_file.log,'Sickness Report not sent. Hence skipped.');
1461: ELSIF l_SR_exists = 'Y' THEN
1462:
1463: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1464: hr_nonrun_asact.insact(
1465: lockingactid => l_child_aa_id
1466: , assignid => l_assignment_id
1467: , pactid => l_payroll_action_id

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

1734: /**************************************************************************/
1735:
1736: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS
1737:
1738: CURSOR cur_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1739: SELECT pai.action_information1 abs_att_id
1740: ,pai.action_information2 rec_dt
1741: ,pai.action_information3 st_dt
1742: ,pai.action_information4 abs_cat

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

1756: WHERE pai.action_context_id = c_assignment_action_id
1757: AND pai.action_information_category = 'NL_DSRR_ABS_INFO'
1758: AND action_context_type = 'AAP';
1759: /**************************************************************************/
1760: CURSOR cur_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1761: SELECT action_information2 test_msg
1762: ,action_information3 tax_no_sender
1763: ,action_information4 role_sender
1764: ,action_information5 contact_per_or_dept

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

1780: WHERE pai.action_context_id = c_assignment_action_id
1781: AND pai.action_information_category = 'NL_DSRR_EMP_INFO'
1782: AND action_context_type = 'AAP';
1783: /**************************************************************************/
1784: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1785: SELECT pai.action_information30 flag
1786: FROM pay_action_information pai
1787: WHERE pai.action_context_id = c_assignment_action_id
1788: AND pai.action_information_category = 'NL_DSR_ABS_INFO'

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

1985: l_start_date DATE := NULL;
1986: l_end_date DATE := NULL;
1987: l_type VARCHAR2(1) := NULL;
1988: /**************************************************************************/
1989: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1990: SELECT assignment_action_id ass_act_id
1991: FROM pay_assignment_actions
1992: WHERE source_action_id = c_assignment_action_id;
1993: /**************************************************************************/

Line 1991: FROM pay_assignment_actions

1987: l_type VARCHAR2(1) := NULL;
1988: /**************************************************************************/
1989: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1990: SELECT assignment_action_id ass_act_id
1991: FROM pay_assignment_actions
1992: WHERE source_action_id = c_assignment_action_id;
1993: /**************************************************************************/
1994: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1995: SELECT locked_action_id parent_id

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

1990: SELECT assignment_action_id ass_act_id
1991: FROM pay_assignment_actions
1992: WHERE source_action_id = c_assignment_action_id;
1993: /**************************************************************************/
1994: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1995: SELECT locked_action_id parent_id
1996: FROM pay_action_interlocks
1997: WHERE locking_action_id = c_assignment_action_id;
1998: /**************************************************************************/

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

1995: SELECT locked_action_id parent_id
1996: FROM pay_action_interlocks
1997: WHERE locking_action_id = c_assignment_action_id;
1998: /**************************************************************************/
1999: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2000: SELECT ppa.payroll_action_id
2001: FROM pay_payroll_actions ppa
2002: ,pay_assignment_actions paa
2003: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 2002: ,pay_assignment_actions paa

1998: /**************************************************************************/
1999: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2000: SELECT ppa.payroll_action_id
2001: FROM pay_payroll_actions ppa
2002: ,pay_assignment_actions paa
2003: WHERE paa.payroll_action_id = ppa.payroll_action_id
2004: AND paa.assignment_action_id = c_assignment_action_id;
2005: /**************************************************************************/
2006: