DBA Data[Home] [Help]

APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on HR_LOOKUPS

Line 525: , hr_lookups hl

521: FROM pay_external_accounts pea
522: , pay_personal_payment_methods_f ppm
523: , pay_org_payment_methods_f pop
524: , pay_pre_payments ppp
525: , hr_lookups hl
526: WHERE ppm.personal_payment_method_id(+) = ppp.personal_payment_method_id
527: AND pop.org_payment_method_id = ppp.org_payment_method_id
528: AND pea.segment3 = hl.lookup_code (+)
529: AND hl.lookup_type(+) = 'SG_ACCOUNT_TYPE'