DBA Data[Home] [Help]

APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on HR_LOOKUPS

Line 531: , hr_lookups hl

527: FROM pay_external_accounts pea
528: , pay_personal_payment_methods_f ppm
529: , pay_org_payment_methods_f pop
530: , pay_pre_payments ppp
531: , hr_lookups hl
532: WHERE ppm.personal_payment_method_id(+) = ppp.personal_payment_method_id
533: AND pop.org_payment_method_id = ppp.org_payment_method_id
534: AND pea.segment3 = hl.lookup_code (+)
535: AND hl.lookup_type(+) = 'SG_ACCOUNT_TYPE'