DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on HR_LOOKUPS

Line 634: , hr_lookups hl

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