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_DSRR_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 894: FROM pay_action_information pai

890: ,p_end_date IN DATE
891: ,p_type IN VARCHAR2) IS
892: SELECT DISTINCT
893: paa.assignment_id assignment_id
894: FROM pay_action_information pai
895: , pay_payroll_actions ppa
896: , per_all_assignments_f paa
897: , per_all_people_f pap
898: WHERE pai.action_context_type = 'AAP'

Line 935: FROM pay_action_information pai

931: ,p_end_date IN DATE
932: ,p_type IN VARCHAR2) IS
933: SELECT DISTINCT
934: paa.assignment_id assignment_id
935: FROM pay_action_information pai
936: , pay_payroll_actions ppa
937: , per_org_structure_versions posv
938: , per_all_assignments_f paa
939: , per_all_people_f pap

Line 996: FROM pay_action_information pai

992: ,p_end_date IN DATE
993: ,p_type IN VARCHAR2) IS
994: SELECT DISTINCT
995: paa.assignment_id assignment_id
996: FROM pay_action_information pai
997: , per_all_assignments_f paa
998: , per_all_people_f pap
999: , pay_payroll_actions ppa
1000: , per_org_structure_versions posv

Line 1246: FROM pay_action_information pai

1242:
1243: CURSOR csr_chk_SR_exists (p_assignment_id IN NUMBER
1244: ,p_abs_start_date IN DATE) IS
1245: SELECT 'Y'
1246: FROM pay_action_information pai
1247: WHERE pai.assignment_id = p_assignment_id
1248: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1249: AND pai.action_information30 = 'N'
1250: AND fnd_date.canonical_to_date (pai.action_information2) = p_abs_start_date;

Line 1323: FROM pay_action_information pai

1319:
1320: CURSOR csr_already_exists(p_abs_att_id NUMBER) IS
1321:
1322: SELECT 'Y'
1323: FROM pay_action_information pai
1324: WHERE pai.action_context_type = 'AAP'
1325: AND pai.action_information_category = 'NL_DSRR_ABS_INFO'
1326: AND pai.action_information1 = p_abs_att_id
1327: AND pai.action_information30 = 'N';

Line 1340: FROM pay_action_information pai

1336: , pai.action_information2 st_dt
1337: , pai.action_information3 end_dt
1338: , pai.action_context_id org_asg_act_id
1339: , pai.action_information_id act_info_id
1340: FROM pay_action_information pai
1341: WHERE pai.assignment_id = p_assignment_id
1342: AND pai.action_context_type = 'AAP'
1343: AND pai.action_information_category = 'NL_DSRR_ABS_INFO'
1344: AND pai.action_information29 = 'NL_SRR'

Line 1485: pay_action_information_api.create_action_information

1481: FETCH csr_get_org_contact_info into l_org_contact_info;
1482: CLOSE csr_get_org_contact_info;
1483:
1484: /* Archiving absence details */
1485: pay_action_information_api.create_action_information
1486: (
1487: p_action_information_id => l_action_info_id
1488: , p_action_context_id => l_child_aa_id
1489: , p_action_context_type => 'AAP'

Line 1538: pay_action_information_api.create_action_information

1534: FETCH csr_numiv_override INTO l_numiv_override;
1535: CLOSE csr_numiv_override;
1536:
1537: /* Archiving Employee and employer info */
1538: pay_action_information_api.create_action_information
1539: ( p_action_information_id => l_action_info_id
1540: , p_action_context_id => l_child_aa_id
1541: , p_action_context_type => 'AAP'
1542: , p_object_version_number => l_ovn

Line 1593: pay_action_information_api.update_action_information

1589: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1590: , lockedactid => r_get_archived_absence.org_asg_act_id);
1591: IF l_type = 'W' THEN
1592: -- Update previous archive incase of withdrawal.
1593: pay_action_information_api.update_action_information
1594: (p_action_information_id => r_get_archived_absence.act_info_id
1595: , p_object_version_number => l_ovn
1596: , p_action_information30 => 'Y'
1597: );

Line 1755: FROM pay_action_information pai

1751: ,pai.action_information13 contact_name
1752: ,pai.action_information14 est_name
1753: ,pai.action_information15 gender
1754: ,pai.action_information16 contact_ph_no
1755: FROM pay_action_information pai
1756: WHERE pai.action_context_id = c_assignment_action_id
1757: AND pai.action_information_category = 'NL_DSRR_ABS_INFO'
1758: AND action_context_type = 'AAP';
1759: /**************************************************************************/

Line 1779: FROM pay_action_information pai

1775: ,action_information21 asg_seq
1776: ,action_information22 emp_num
1777: ,action_information23 est_name
1778: ,action_information24 gender_contact
1779: FROM pay_action_information pai
1780: WHERE pai.action_context_id = c_assignment_action_id
1781: AND pai.action_information_category = 'NL_DSRR_EMP_INFO'
1782: AND action_context_type = 'AAP';
1783: /**************************************************************************/

Line 1786: FROM pay_action_information pai

1782: AND action_context_type = 'AAP';
1783: /**************************************************************************/
1784: CURSOR cur_withdrawl_flag(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1785: SELECT pai.action_information30 flag
1786: FROM pay_action_information pai
1787: WHERE pai.action_context_id = c_assignment_action_id
1788: AND pai.action_information_category = 'NL_DSR_ABS_INFO'
1789: AND action_context_type = 'AAP';
1790: /**************************************************************************/