DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on HR_LOOKUPS

Line 635: , hr_lookups hl

631: FROM pay_external_accounts pea
632: , pay_personal_payment_methods_f ppm
633: , pay_org_payment_methods_f pop
634: , pay_pre_payments ppp
635: , hr_lookups hl
636: WHERE ppm.personal_payment_method_id(+) = ppp.personal_payment_method_id
637: AND pop.org_payment_method_id = ppp.org_payment_method_id
638: AND pea.segment3 = hl.lookup_code (+)
639: AND hl.lookup_type(+) = 'HK_ACCOUNT_TYPE'