DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 175: from pay_external_accounts pea,

171: 'PER_PAY_METHOD_ID=C',
172: ppp.personal_payment_method_id,
173: 'TRANSFER_ASG_ACTION_ID=P',
174: paa.assignment_action_id
175: from pay_external_accounts pea,
176: pay_personal_payment_methods ppm,
177: per_assignments pa,
178: pay_pre_payments ppp,
179: pay_assignment_actions paa

Line 325: from pay_external_accounts opea,

321: 'PER_PAY_METHOD_ID=C',
322: oppp.personal_payment_method_id,
323: 'TRANSFER_ASG_ACTION_ID=P',
324: opaa.assignment_action_id
325: from pay_external_accounts opea,
326: pay_personal_payment_methods oppm,
327: per_assignments opa,
328: pay_pre_payments oppp,
329: pay_assignment_actions opaa

Line 495: pay_external_accounts pea

491: from pay_assignment_actions paa,
492: pay_pre_payments ppp,
493: per_assignments pa,
494: pay_personal_payment_methods ppm,
495: pay_external_accounts pea
496: where paa.payroll_action_id =
497: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
498: and paa.pre_payment_id = ppp.pre_payment_id
499: and paa.assignment_id = pa.assignment_id

Line 671: pay_external_accounts opea,

667: oppp.personal_payment_method_id,
668: 'TRANSFER_ASG_ACTION_ID=P',
669: opaa.assignment_action_id
670: from
671: pay_external_accounts opea,
672: pay_personal_payment_methods oppm,
673: per_assignments opa,
674: pay_pre_payments oppp,
675: pay_assignment_actions opaa