APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_LOOKUPS

Line 1106: ,hr_lookups lu

1102: ,pay_action_contexts pac1
1103: ,pay_action_contexts pac2
1104: ,ff_contexts ctx1
1105: ,ff_contexts ctx2
1106: ,hr_lookups lu
1107: ,hr_organization_information orginf1
1108: ,hr_all_organization_units org2
1109: ,hr_organization_information orginf2
1110: ,pay_user_tables t

Line 3752: FROM hr_lookups lu

3748: ,DECODE(cde_dtl.action_information4, 'Y',rep_cde.action_information2, 'TOTAL_OTHER_CODES');
3749: --
3750: CURSOR csr_SI_STATUS IS
3751: SELECT lu.lookup_code si_status
3752: FROM hr_lookups lu
3753: WHERE lu.lookup_type = 'NO_LEGAL_EMP_SI_STATUS';
3754: --
3755: l_total_below_rep_limit NUMBER;
3756: l_xml_element_count NUMBER := 1;

Line 4583: FROM hr_lookups lu

4579: ,DECODE(cde_dtl.action_information4, 'Y',rep_cde.action_information2, 'TOTAL_OTHER_CODES');
4580: --
4581: CURSOR csr_SI_STATUS IS
4582: SELECT lu.lookup_code si_status
4583: FROM hr_lookups lu
4584: WHERE lu.lookup_type = 'NO_LEGAL_EMP_SI_STATUS';
4585: --
4586: l_total_below_rep_limit NUMBER;
4587: l_xml_element_count NUMBER := 1;