DBA Data[Home] [Help]

APPS.PQP_GB_PSI_BASIC_DATA dependencies on PAY_EXTERNAL_ACCOUNTS

Line 81: from PAY_PERSONAL_PAYMENT_METHODS_F pppm,pay_external_accounts pea

77: ,p_effective_date DATE
78: ,p_assignment_id NUMBER
79: ) IS
80: select pea.segment3, pea.segment4, pea.segment6, pea.segment7 --personal.external_account_id
81: from PAY_PERSONAL_PAYMENT_METHODS_F pppm,pay_external_accounts pea
82: where pppm.external_account_id = pea.external_account_id
83: and pppm.business_group_id = p_business_group_id
84: and pppm.assignment_id = p_assignment_id
85: and p_effective_date