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

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

1190: ,p_chunk IN NUMBER)
1191: IS
1192: l_asg_act_id NUMBER;
1193: BEGIN
1194: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1195: hr_nonrun_asact.insact(
1196: lockingactid => l_asg_act_id
1197: ,assignid => p_assignid
1198: ,pactid => p_pactid

Line 1367: ,pay_assignment_actions paa

1363: ,decode (pab.abs_information25,'Y','1','N','2') work_long_all
1364: ,pab.abs_information26 temp_cont
1365: FROM per_absence_attendance_types paat
1366: ,per_absence_attendances pab
1367: ,pay_assignment_actions paa
1368: ,per_all_assignments_f pas
1369: WHERE paat.absence_category = 'S'
1370: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
1371: AND paat.business_group_id = pab.business_group_id

Line 1713: ,pay_assignment_actions paa

1709: CURSOR c_get_pact_chunk(c_assignment_action_id IN NUMBER ) IS
1710: SELECT ppa.payroll_action_id
1711: ,paa.chunk_number
1712: FROM pay_payroll_actions ppa
1713: ,pay_assignment_actions paa
1714: WHERE paa.payroll_action_id = ppa.payroll_action_id
1715: AND paa.assignment_action_id = c_assignment_action_id;
1716: /**************************************************************************/
1717: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS

Line 1720: FROM pay_assignment_actions paa

1716: /**************************************************************************/
1717: CURSOR c_get_assid_chunk(c_assignment_action_id IN NUMBER ) IS
1718: SELECT paa.assignment_id
1719: ,paa.chunk_number
1720: FROM pay_assignment_actions paa
1721: ,pay_payroll_actions ppa
1722: WHERE paa.payroll_action_id = ppa.payroll_action_id
1723: AND paa.assignment_action_id = c_assignment_action_id;
1724: /**************************************************************************/

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

1827: IF l_exists = 'Y' THEN
1828: fnd_file.put_line(fnd_file.log,'Sickness Report already sent. Hence skipped.');
1829: ELSIF l_exists = 'N' THEN
1830:
1831: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1832:
1833: hr_nonrun_asact.insact(
1834: lockingactid => l_child_aa_id
1835: , assignid => l_assignment_id

Line 2356: CURSOR cur_conn_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

2352:
2353: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS
2354:
2355:
2356: CURSOR cur_conn_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2357: SELECT pai.action_information2 conn_count
2358: ,pai.action_information3 start1
2359: ,pai.action_information4 end1
2360: ,pai.action_information5 start2

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

2388: AND pai.action_information_category = 'NL_DSR_CONN_ABS_INFO'
2389: AND action_context_type = 'AAP';
2390:
2391: /**************************************************************************/
2392: CURSOR cur_abs_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2393: SELECT pai.action_information1 abs_att_id
2394: ,pai.action_information2 start_date
2395: ,pai.action_information3 end_date
2396: ,pai.action_information4 abs_cat

Line 2415: CURSOR cur_sick_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

2411: WHERE pai.action_context_id=c_assignment_action_id
2412: AND pai.ACTION_INFORMATION_CATEGORY = 'NL_DSR_ABS_INFO'
2413: AND action_context_type = 'AAP';
2414: /**************************************************************************/
2415: CURSOR cur_sick_info_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2416: SELECT pai.action_information2 sick_ref
2417: ,pai.action_information3 noti_date
2418: ,pai.action_information4 dsr_st_dt
2419: ,pai.action_information5 code_pymt

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

2445: WHERE pai.action_context_id = c_assignment_action_id
2446: AND pai.action_information_category = 'NL_DSR_SICK_INFO'
2447: AND action_context_type = 'AAP';
2448: /**************************************************************************/
2449: CURSOR cur_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2450: SELECT action_information2 sofi_number
2451: ,action_information3 date_of_birth
2452: ,action_information4 gender
2453: ,action_information5 init

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

2479: WHERE pai.action_context_id = c_assignment_action_id
2480: AND pai.action_information_category = 'NL_DSR_EMP_INFO'
2481: AND action_context_type = 'AAP';
2482: /**************************************************************************/
2483: CURSOR cur_addr_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2484: SELECT action_information2 style
2485: ,action_information3 start_date
2486: ,action_information4 end_date
2487: ,action_information5 postal

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

2521: AND fdd.name = 'SHORT_TEXT'
2522: AND fdd.language = 'US'
2523: AND fdst.media_id = fd.media_id;
2524: /**************************************************************************/
2525: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2526: SELECT pai.action_information30 flag
2527: FROM pay_action_information pai
2528: WHERE pai.action_context_id = c_assignment_action_id
2529: AND pai.action_information_category = 'NL_DSR_ABS_INFO'

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

2977: l_start_date DATE := NULL;
2978: l_end_date DATE := NULL;
2979: l_type VARCHAR2(1) := NULL;
2980: /**************************************************************************/
2981: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2982: SELECT assignment_action_id ass_act_id
2983: FROM pay_assignment_actions
2984: WHERE source_action_id = c_assignment_action_id;
2985: /**************************************************************************/

Line 2983: FROM pay_assignment_actions

2979: l_type VARCHAR2(1) := NULL;
2980: /**************************************************************************/
2981: CURSOR cur_get_child_act_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2982: SELECT assignment_action_id ass_act_id
2983: FROM pay_assignment_actions
2984: WHERE source_action_id = c_assignment_action_id;
2985: /**************************************************************************/
2986: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2987: SELECT locked_action_id parent_id

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

2982: SELECT assignment_action_id ass_act_id
2983: FROM pay_assignment_actions
2984: WHERE source_action_id = c_assignment_action_id;
2985: /**************************************************************************/
2986: CURSOR get_parent_asg_ids(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2987: SELECT locked_action_id parent_id
2988: FROM pay_action_interlocks
2989: WHERE locking_action_id = c_assignment_action_id;
2990: /**************************************************************************/

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

2987: SELECT locked_action_id parent_id
2988: FROM pay_action_interlocks
2989: WHERE locking_action_id = c_assignment_action_id;
2990: /**************************************************************************/
2991: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2992: SELECT ppa.payroll_action_id
2993: FROM pay_payroll_actions ppa
2994: ,pay_assignment_actions paa
2995: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 2994: ,pay_assignment_actions paa

2990: /**************************************************************************/
2991: CURSOR get_pact_id(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
2992: SELECT ppa.payroll_action_id
2993: FROM pay_payroll_actions ppa
2994: ,pay_assignment_actions paa
2995: WHERE paa.payroll_action_id = ppa.payroll_action_id
2996: AND paa.assignment_action_id = c_assignment_action_id;
2997: /**************************************************************************/
2998: