DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_EXTERNAL_ACCOUNTS

Line 147: pay_external_accounts pea

143: ,segment20 ,segment21 ,segment22 ,segment23
144: ,segment24 ,segment25 ,segment26 ,segment27
145: ,segment28 ,segment29 ,segment30 ,org_payment_method_id
146: FROM pay_personal_payment_methods_f pppm,
147: pay_external_accounts pea
148: WHERE --pppm.assignment_id = p_assignment_id
149: pppm.personal_payment_method_id = p_per_pay_method
150: AND pppm.external_account_id = pea.external_account_id
151: AND p_effective_date between pppm.EFFECTIVE_START_DATE

Line 457: pay_external_accounts pea

453: ,pmeth_information13 ,pmeth_information14 ,pmeth_information15
454: ,pmeth_information16 ,pmeth_information17 ,pmeth_information18
455: ,pmeth_information19 ,pmeth_information20
456: FROM pay_org_payment_methods_f popm,
457: pay_external_accounts pea
458: WHERE org_payment_method_id = p_org_payment_method_id
459: AND popm.external_account_id = pea.external_account_id
460: AND p_effective_date between popm.EFFECTIVE_START_DATE
461: and popm.EFFECTIVE_END_DATE;