DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_EXTERNAL_ACCOUNTS

Line 151: pay_external_accounts pea

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

Line 471: pay_external_accounts pea

467: ,pmeth_information13 ,pmeth_information14 ,pmeth_information15
468: ,pmeth_information16 ,pmeth_information17 ,pmeth_information18
469: ,pmeth_information19 ,pmeth_information20
470: FROM pay_org_payment_methods_f popm,
471: pay_external_accounts pea
472: WHERE org_payment_method_id = p_org_payment_method_id
473: AND popm.external_account_id = pea.external_account_id
474: AND p_effective_date between popm.EFFECTIVE_START_DATE
475: and popm.EFFECTIVE_END_DATE;