DBA Data[Home] [Help]

APPS.PQP_GB_PSI_BASIC_DATA dependencies on PAY_EXTERNAL_ACCOUNTS

Line 74: from PAY_PERSONAL_PAYMENT_METHODS_F pppm,pay_external_accounts pea

70: ,p_effective_date DATE
71: ,p_assignment_id NUMBER
72: ) IS
73: select pea.segment3, pea.segment4, pea.segment6, pea.segment7 --personal.external_account_id
74: from PAY_PERSONAL_PAYMENT_METHODS_F pppm,pay_external_accounts pea
75: where pppm.external_account_id = pea.external_account_id
76: and pppm.business_group_id = p_business_group_id
77: and pppm.assignment_id = p_assignment_id
78: and p_effective_date