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_ACTION_INFORMATION

Line 1024: FROM pay_action_information pai

1020: ,p_end_date IN DATE
1021: ,p_type IN VARCHAR2) IS
1022: SELECT DISTINCT
1023: paa.assignment_id assignment_id
1024: FROM pay_action_information pai
1025: ,pay_payroll_actions ppa
1026: ,per_all_assignments_f paa
1027: ,per_all_people_f pap
1028: WHERE pai.action_context_type = 'AAP'

Line 1065: FROM pay_action_information pai

1061: ,p_end_date IN DATE
1062: ,p_type IN VARCHAR2) IS
1063: SELECT DISTINCT
1064: paa.assignment_id assignment_id
1065: FROM pay_action_information pai
1066: ,pay_payroll_actions ppa
1067: ,per_org_structure_versions posv
1068: ,per_all_assignments_f paa
1069: ,per_all_people_f pap

Line 1126: FROM pay_action_information pai

1122: ,p_end_date IN DATE
1123: ,p_type IN VARCHAR2) IS
1124: SELECT DISTINCT
1125: paa.assignment_id assignment_id
1126: FROM pay_action_information pai
1127: ,per_all_assignments_f paa
1128: ,per_all_people_f pap
1129: ,pay_payroll_actions ppa
1130: ,per_org_structure_versions posv

Line 1387: FROM pay_action_information pai

1383: /**************************************************************************/
1384:
1385: CURSOR csr_already_exists(p_assignment_id IN NUMBER, p_abs_start_date IN DATE) IS
1386: SELECT 'Y'
1387: FROM pay_action_information pai
1388: WHERE pai.action_context_type = 'AAP'
1389: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1390: AND pai.ASSIGNMENT_ID = p_assignment_id
1391: AND fnd_date.canonical_to_date(pai.action_information2) = p_abs_start_date

Line 1404: FROM pay_action_information pai

1400: ,pai.action_information2 st_dt
1401: ,pai.action_information3 end_dt
1402: ,pai.action_context_id org_asg_act_id
1403: ,pai.action_information_id act_info_id
1404: FROM pay_action_information pai
1405: WHERE pai.assignment_id = p_assignment_id
1406: AND pai.action_context_type = 'AAP'
1407: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1408: AND pai.action_information29 = 'NL_SR'

Line 1866: pay_action_information_api.create_action_information

1862: CLOSE csr_get_org_info;
1863: END IF;
1864:
1865: /* Archiving absence details */
1866: pay_action_information_api.create_action_information
1867: (
1868: p_action_information_id => l_action_info_id
1869: , p_action_context_id => l_child_aa_id
1870: , p_action_context_type => 'AAP'

Line 1917: pay_action_information_api.create_action_information

1913: END LOOP;
1914:
1915: IF connected_absence_count>0 THEN
1916: -- Archiving connected absence details
1917: pay_action_information_api.create_action_information
1918: (
1919: p_action_information_id => l_action_info_id
1920: , p_action_context_id => l_child_aa_id
1921: , p_action_context_type => 'AAP'

Line 1964: pay_action_information_api.create_action_information

1960:
1961:
1962:
1963:
1964: pay_action_information_api.create_action_information
1965: (
1966: p_action_information_id => l_action_info_id
1967: , p_action_context_id => l_child_aa_id
1968: , p_action_context_type => 'AAP'

Line 2048: pay_action_information_api.create_action_information

2044: OPEN csr_get_job(l_assignment_id, l_abs_start_date);
2045: FETCH csr_get_job INTO l_job_name;
2046: CLOSE csr_get_job;
2047:
2048: pay_action_information_api.create_action_information
2049: (
2050: p_action_information_id => l_action_info_id
2051: , p_action_context_id => l_child_aa_id
2052: , p_action_context_type => 'AAP'

Line 2110: pay_action_information_api.create_action_information

2106:
2107: hr_utility.trace('Sickness Address Style : ' || l_sick_addr.style );
2108: IF l_sick_addr.style IS NOT NULL THEN
2109: /* Archiving sickness address */
2110: pay_action_information_api.create_action_information
2111: ( p_action_information_id => l_action_info_id
2112: , p_action_context_id => l_child_aa_id
2113: , p_action_context_type => 'AAP'
2114: , p_object_version_number => l_ovn

Line 2150: pay_action_information_api.create_action_information

2146: hr_utility.trace('Person Address Style : ' || l_person_addr.style);
2147: IF l_person_addr.style IS NOT NULL THEN
2148:
2149: /* Archiving sickness address */
2150: pay_action_information_api.create_action_information
2151: (
2152: p_action_information_id => l_action_info_id
2153: , p_action_context_id => l_child_aa_id
2154: , p_action_context_type => 'AAP'

Line 2207: pay_action_information_api.update_action_information

2203: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
2204: , lockedactid => r_get_archived_absence.org_asg_act_id);
2205: IF l_type = 'W' THEN
2206: -- Update previous archive incase of withdrawal.
2207: pay_action_information_api.update_action_information
2208: (p_action_information_id => r_get_archived_absence.act_info_id
2209: , p_object_version_number => l_ovn
2210: , p_action_information30 => 'Y'
2211: );

Line 2386: FROM pay_action_information pai

2382: ,pai.action_information27 start13
2383: ,pai.action_information28 end13
2384: ,pai.action_information29 start14
2385: ,pai.action_information30 end14
2386: FROM pay_action_information pai
2387: WHERE pai.action_context_id = c_assignment_action_id
2388: AND pai.action_information_category = 'NL_DSR_CONN_ABS_INFO'
2389: AND action_context_type = 'AAP';
2390:

Line 2410: FROM pay_action_information pai

2406: ,pai.action_information14 employer_acc_no
2407: ,pai.action_information17 est_name
2408: ,pai.action_information18 gender
2409: ,pai.action_information19 employer_iban
2410: FROM pay_action_information pai
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: /**************************************************************************/

Line 2444: FROM pay_action_information pai

2440: ,pai.action_information26 gender
2441: ,pai.action_information27 contact_ph_no
2442: ,pai.action_information28 conn_absence_count
2443: ,pai.action_information30 l_29bzw
2444: FROM pay_action_information pai
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: /**************************************************************************/

Line 2478: FROM pay_action_information pai

2474: ,action_information26 appr_temp_worker
2475: ,action_information27 emp_num
2476: ,action_information28 ass_start_date
2477: ,action_information29 ass_end_date
2478: FROM pay_action_information pai
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: /**************************************************************************/

Line 2503: FROM pay_action_information pai

2499: ,action_information17 for_sick_ph_no
2500: ,action_information18 sick_mobile_no
2501: ,action_information19 address1
2502: ,action_information20 address2
2503: FROM pay_action_information pai
2504: WHERE pai.action_context_id = c_assignment_action_id
2505: AND pai.action_information_category = 'NL_DSR_ADDRESS'
2506: AND action_context_type = 'AAP';
2507: /**************************************************************************/

Line 2527: FROM pay_action_information pai

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'
2530: AND action_context_type = 'AAP';
2531: /**************************************************************************/