APPS.PAY_AU_PAYMENT_SUMMARY dependencies on HR_LOOKUPS

Line 756: hr_lookups

752: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp
753: )
754: and not exists ( select aei_information1
755: from per_assignment_extra_info,
756: hr_lookups
757: where assignment_id = a.assignment_id
758: and aei_information1 is not null
759: and aei_information1 = lookup_code
760: and nvl(aei_information2,v_reg_emp) = decode(aei_information2,'-999',aei_information2,v_reg_emp) -- 2610141 and 4000955

Line 836: hr_lookups

832: and pay_core_utils.get_parameter('FINANCIAL_YEAR',paas.legislative_parameters) = v_financial_year
833: and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',paas.legislative_parameters) = v_reg_emp) --2610141
834: and not exists ( select aei_information1
835: from per_assignment_extra_info,
836: hr_lookups
837: where assignment_id = a.assignment_id
838: and aei_information1 is not null
839: and aei_information1 = lookup_code
840: and nvl(aei_information2,v_reg_emp) = decode(aei_information2,'-999',aei_information2,v_reg_emp) -- 2610141 and 4000955

Line 936: hr_lookups

932: )
933: AND NOT EXISTS
934: ( SELECT aei_information1
935: FROM per_assignment_extra_info,
936: hr_lookups
937: WHERE assignment_id = a.assignment_id
938: AND aei_information1 IS NOT NULL
939: AND aei_information1 = lookup_code
940: AND nvl(aei_information2,v_reg_emp) = decode(aei_information2,'-999',aei_information2,v_reg_emp) -- 2610141 and 4000955

Line 5692: FROM HR_LOOKUPS

5688:
5689: CURSOR csr_lookup_code (c_financial_year varchar2)
5690: IS
5691: SELECT LOOKUP_CODE
5692: FROM HR_LOOKUPS
5693: WHERE lookup_type = 'AU_PS_FINANCIAL_YEAR'
5694: AND enabled_flag = 'Y'
5695: AND meaning =c_financial_year;
5696: