APPS.PER_NL_LTSR_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 1234: FROM pay_action_information pai

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

Line 1298: FROM pay_action_information pai

1294: ,pai.action_information2 st_dt
1295: ,pai.action_information3 end_dt
1296: ,pai.action_context_id org_asg_act_id
1297: ,pai.action_information_id act_info_id
1298: FROM pay_action_information pai
1299: WHERE pai.assignment_id = p_assignment_id
1300: AND pai.action_context_type = 'AAP'
1301: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1302: AND pai.action_information29 = 'NL_LTSR'

Line 1442: pay_action_information_api.create_action_information

1438: FETCH csr_get_sickness_contact INTO l_sickness_contact;
1439: CLOSE csr_get_sickness_contact;
1440:
1441: /* Archiving absence details */
1442: pay_action_information_api.create_action_information
1443: (
1444: p_action_information_id => l_action_info_id
1445: , p_action_context_id => l_child_aa_id
1446: , p_action_context_type => 'AAP'

Line 1490: pay_action_information_api.create_action_information

1486: FETCH csr_numiv_override INTO l_numiv_override;
1487: CLOSE csr_numiv_override;
1488:
1489: /* Archiving Employee and employer info */
1490: pay_action_information_api.create_action_information
1491: (
1492: p_action_information_id => l_action_info_id
1493: , p_action_context_id => l_child_aa_id
1494: , p_action_context_type => 'AAP'

Line 1546: pay_action_information_api.update_action_information

1542: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1543: , lockedactid => r_get_archived_absence.org_asg_act_id);
1544: IF l_type = 'W' THEN
1545: -- Update previous archive incase of withdrawal.
1546: pay_action_information_api.update_action_information
1547: (p_action_information_id => r_get_archived_absence.act_info_id
1548: , p_object_version_number => l_ovn
1549: , p_action_information30 => 'Y'
1550: );

Line 1707: FROM pay_action_information pai

1703: ,pai.action_information10 contact_name
1704: ,pai.action_information11 est_name
1705: ,pai.action_information12 contact_gender
1706: ,pai.action_information13 contact_ph
1707: FROM pay_action_information pai
1708: WHERE pai.action_context_id = c_assignment_action_id
1709: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1710: AND action_context_type = 'AAP';
1711: /**************************************************************************/

Line 1731: FROM pay_action_information pai

1727: ,action_information21 asg_seq
1728: ,action_information22 emp_num
1729: ,action_information23 est_name
1730: ,action_information24 gender_contact
1731: FROM pay_action_information pai
1732: WHERE pai.action_context_id = c_assignment_action_id
1733: AND pai.action_information_category = 'NL_LTSR_EMP_INFO'
1734: AND action_context_type = 'AAP';
1735:

Line 1739: FROM pay_action_information pai

1735:
1736: /**************************************************************************/
1737: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
1738: SELECT pai.action_information30 flag
1739: FROM pay_action_information pai
1740: WHERE pai.action_context_id = c_assignment_action_id
1741: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
1742: AND action_context_type = 'AAP';
1743: /**************************************************************************/