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_WAZO_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 1214: ,pay_assignment_actions paa

1210: ,to_char (fnd_date.canonical_to_date(pab.abs_information6),'YYYYMMDD') est_dob
1211: ,to_char (pab.date_start,'YYYYMMDD') wazo_st_dt
1212: FROM per_absence_attendance_types paat
1213: ,per_absence_attendances pab
1214: ,pay_assignment_actions paa
1215: ,per_all_assignments_f pas
1216: WHERE paat.absence_category = 'WAZO'
1217: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1218: AND paat.business_group_id = pab.business_group_id

Line 1477: ,pay_assignment_actions paa

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

Line 1484: FROM pay_assignment_actions paa

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

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

1580: IF l_exists = 'Y' THEN
1581: fnd_file.put_line(fnd_file.log,'WAZO Report already sent. Hence skipped.');
1582: ELSIF l_exists = 'N' THEN
1583:
1584: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1585:
1586: hr_nonrun_asact.insact(
1587: lockingactid => l_child_aa_id
1588: , assignid => l_assignment_id

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

1986:
1987: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS
1988:
1989:
1990: CURSOR cur_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
1991: SELECT pai.action_information1 abs_att_id
1992: ,pai.action_information2 start_date
1993: ,pai.action_information3 end_date
1994: ,pai.action_information4 abs_cat

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

2009: WHERE pai.action_context_id = c_assignment_action_id
2010: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
2011: AND action_context_type = 'AAP';
2012: /**************************************************************************/
2013: CURSOR cur_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2014: SELECT action_information2 test_msg
2015: ,action_information3 tax_no_sender
2016: ,action_information4 role_sender
2017: ,action_information5 contact_per_or_dept

Line 2046: CURSOR cur_addr_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

2042: WHERE pai.action_context_id = c_assignment_action_id
2043: AND pai.action_information_category = 'NL_WAZO_EMP_INFO'
2044: AND action_context_type = 'AAP';
2045: /**************************************************************************/
2046: CURSOR cur_addr_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2047: SELECT action_information2 style
2048: ,action_information3 start_date
2049: ,action_information4 end_date
2050: ,action_information5 postal

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

2084: AND fdd.name = 'SHORT_TEXT'
2085: AND fdd.language = 'US'
2086: AND fdst.media_id = fd.media_id;
2087: /**************************************************************************/
2088: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
2089: SELECT pai.action_information30 flag
2090: FROM pay_action_information pai
2091: WHERE pai.action_context_id = c_assignment_action_id
2092: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'

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

2381: l_start_date DATE := NULL;
2382: l_end_date DATE := NULL;
2383: l_type VARCHAR2(1) := NULL;
2384: /**************************************************************************/
2385: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2386: SELECT assignment_action_id ass_act_id
2387: FROM pay_assignment_actions
2388: WHERE source_action_id = c_assignment_action_id;
2389: /**************************************************************************/

Line 2387: FROM pay_assignment_actions

2383: l_type VARCHAR2(1) := NULL;
2384: /**************************************************************************/
2385: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2386: SELECT assignment_action_id ass_act_id
2387: FROM pay_assignment_actions
2388: WHERE source_action_id = c_assignment_action_id;
2389: /**************************************************************************/
2390: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2391: SELECT locked_action_id parent_id

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

2386: SELECT assignment_action_id ass_act_id
2387: FROM pay_assignment_actions
2388: WHERE source_action_id = c_assignment_action_id;
2389: /**************************************************************************/
2390: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2391: SELECT locked_action_id parent_id
2392: FROM pay_action_interlocks
2393: WHERE locking_action_id = c_assignment_action_id;
2394: /**************************************************************************/

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

2391: SELECT locked_action_id parent_id
2392: FROM pay_action_interlocks
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

Line 2398: ,pay_assignment_actions paa

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