DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 177: from pay_external_accounts pea,

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

Line 327: from pay_external_accounts opea,

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

Line 497: pay_external_accounts pea

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

Line 673: pay_external_accounts opea,

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