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_ACTION_INFORMATION

Line 889: FROM pay_action_information pai

885: ,p_end_date IN DATE
886: ,p_type IN VARCHAR2) IS
887: SELECT DISTINCT
888: paa.assignment_id assignment_id
889: FROM pay_action_information pai
890: ,pay_payroll_actions ppa
891: ,per_all_assignments_f paa
892: ,per_all_people_f pap
893: WHERE pai.action_context_type = 'AAP'

Line 930: FROM pay_action_information pai

926: ,p_end_date IN DATE
927: ,p_type IN VARCHAR2) IS
928: SELECT DISTINCT
929: paa.assignment_id assignment_id
930: FROM pay_action_information pai
931: ,pay_payroll_actions ppa
932: ,per_org_structure_versions posv
933: ,per_all_assignments_f paa
934: ,per_all_people_f pap

Line 991: FROM pay_action_information pai

987: ,p_end_date IN DATE
988: ,p_type IN VARCHAR2) IS
989: SELECT DISTINCT
990: paa.assignment_id assignment_id
991: FROM pay_action_information pai
992: ,per_all_assignments_f paa
993: ,per_all_people_f pap
994: ,pay_payroll_actions ppa
995: ,per_org_structure_versions posv

Line 1233: FROM pay_action_information pai

1229: /**************************************************************************/
1230:
1231: CURSOR csr_already_exists(p_assignment_id IN NUMBER, p_abs_start_date IN DATE) IS
1232: SELECT 'Y'
1233: FROM pay_action_information pai
1234: WHERE pai.action_context_type = 'AAP'
1235: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
1236: AND pai.ASSIGNMENT_ID = p_assignment_id
1237: AND fnd_date.canonical_to_date(pai.action_information2) = p_abs_start_date

Line 1250: FROM pay_action_information pai

1246: ,pai.action_information2 st_dt
1247: ,pai.action_information3 end_dt
1248: ,pai.action_context_id org_asg_act_id
1249: ,pai.action_information_id act_info_id
1250: FROM pay_action_information pai
1251: WHERE pai.assignment_id = p_assignment_id
1252: AND pai.action_context_type = 'AAP'
1253: AND pai.action_information_category = 'NL_WAZO_ABS_INFO'
1254: AND pai.action_information29 = 'NL_WAZO'

Line 1611: pay_action_information_api.create_action_information

1607: FETCH csr_get_employer_bank_info into l_employer_bank;
1608: CLOSE csr_get_employer_bank_info;
1609:
1610: /* Archiving absence details */
1611: pay_action_information_api.create_action_information
1612: (
1613: p_action_information_id => l_action_info_id
1614: , p_action_context_id => l_child_aa_id
1615: , p_action_context_type => 'AAP'

Line 1681: pay_action_information_api.create_action_information

1677: OPEN csr_numiv_override(l_assignment_id);
1678: FETCH csr_numiv_override INTO l_numiv_override;
1679: CLOSE csr_numiv_override;
1680:
1681: pay_action_information_api.create_action_information
1682: (
1683: p_action_information_id => l_action_info_id
1684: , p_action_context_id => l_child_aa_id
1685: , p_action_context_type => 'AAP'

Line 1742: pay_action_information_api.create_action_information

1738:
1739: hr_utility.trace('Sickness Address Style : ' || l_sick_addr.style);
1740: IF l_sick_addr.style IS NOT NULL THEN
1741: /* Archiving sickness address */
1742: pay_action_information_api.create_action_information
1743: ( p_action_information_id => l_action_info_id
1744: , p_action_context_id => l_child_aa_id
1745: , p_action_context_type => 'AAP'
1746: , p_object_version_number => l_ovn

Line 1782: pay_action_information_api.create_action_information

1778: IF l_person_addr.style IS NOT NULL THEN
1779: hr_utility.trace('Person Address Style : ' || l_person_addr.style);
1780:
1781: /* Archieving sickness address */
1782: pay_action_information_api.create_action_information
1783: (
1784: p_action_information_id => l_action_info_id
1785: , p_action_context_id => l_child_aa_id
1786: , p_action_context_type => 'AAP'

Line 1839: pay_action_information_api.update_action_information

1835: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1836: , lockedactid => r_get_archived_absence.org_asg_act_id);
1837: IF l_type = 'W' THEN
1838: -- Update previous archive incase of withdrawal.
1839: pay_action_information_api.update_action_information
1840: (p_action_information_id => r_get_archived_absence.act_info_id
1841: , p_object_version_number => l_ovn
1842: , p_action_information30 => 'Y'
1843: );

Line 2008: FROM pay_action_information pai

2004: ,pai.action_information14 employer_acc_no
2005: ,pai.action_information17 employer_iban
2006: ,pai.action_information18 spl_sit
2007: ,pai.action_information19 est_dob
2008: FROM pay_action_information pai
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: /**************************************************************************/

Line 2041: FROM pay_action_information pai

2037: ,action_information25 est_name
2038: ,action_information26 gender_contact
2039: ,action_information27 ass_start_date
2040: ,action_information28 ass_end_date
2041: FROM pay_action_information pai
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: /**************************************************************************/

Line 2066: FROM pay_action_information pai

2062: ,action_information17 for_sick_ph_no
2063: ,action_information18 sick_mobile_no
2064: ,action_information19 address1
2065: ,action_information20 address2
2066: FROM pay_action_information pai
2067: WHERE pai.action_context_id = c_assignment_action_id
2068: AND pai.action_information_category = 'NL_WAZO_ADDRESS'
2069: AND action_context_type = 'AAP';
2070: /**************************************************************************/

Line 2090: FROM pay_action_information pai

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