APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_LOOKUPS

Line 1234: ,hr_lookups lu

1230: ,pay_action_contexts pac1
1231: ,pay_action_contexts pac2
1232: ,ff_contexts ctx1
1233: ,ff_contexts ctx2
1234: ,hr_lookups lu
1235: ,hr_organization_information orginf1
1236: ,hr_all_organization_units org2
1237: ,hr_organization_information orginf2
1238: ,pay_user_tables t

Line 4497: FROM hr_lookups lu

4493: */
4494: --
4495: /* CURSOR csr_SI_STATUS IS
4496: SELECT lu.lookup_code si_status
4497: FROM hr_lookups lu
4498: WHERE lu.lookup_type = 'NO_LEGAL_EMP_SI_STATUS';*/
4499: --
4500: l_total_below_rep_limit NUMBER;
4501: l_xml_element_count NUMBER := 1;

Line 5502: FROM hr_lookups lu

5498: ,DECODE(cde_dtl.action_information4, 'Y',rep_cde.action_information2, 'TOTAL_OTHER_CODES');
5499: --
5500: CURSOR csr_SI_STATUS IS
5501: SELECT lu.lookup_code si_status
5502: FROM hr_lookups lu
5503: WHERE lu.lookup_type = 'NO_LEGAL_EMP_SI_STATUS';
5504: --
5505: l_total_below_rep_limit NUMBER;
5506: l_xml_element_count NUMBER := 1;

Line 6991: SELECT l.MEANING FROM hr_lookups l

6987: addl_info VARCHAR2(30);
6988: l_file_name VARCHAR2(70);
6989: l_title varchar2(25) := 'L'||utl_raw.cast_to_varchar2('C3B8')||'nns- og trekkoppgave';
6990: /*CURSOR csr_country_code(p_country varchar2) IS
6991: SELECT l.MEANING FROM hr_lookups l
6992: WHERE l.lookup_type='NO_LAND_CODES'
6993: and sysdate between nvl(l.START_DATE_ACTIVE , to_date('01/01/0001','DD/MM/YYYY'))
6994: and nvl(l.END_DATE_ACTIVE , to_date('31/12/4712','DD/MM/YYYY'))
6995: --and l1.lookup_type= 'NO_COUNTRY_CODES'