DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_PAYMENT_TYPES

Line 507: pay_payment_types ppt,

503: procedure reset_prenote(p_assact_id in number) is
504: cursor get_accnts_to_reset(asgact in number) is
505: select pea.external_account_id
506: from pay_external_accounts pea,
507: pay_payment_types ppt,
508: pay_personal_payment_methods_f ppm,
509: pay_org_payment_methods_f opm,
510: pay_pre_payments ppp,
511: pay_payroll_actions ppa,

Line 1217: pay_payment_types ppt

1213: end if;
1214: select ppt.payment_type_name
1215: into l_action_name
1216: from pay_payroll_actions pac,
1217: pay_payment_types ppt
1218: where pac.payroll_action_id = p_info.pact_id
1219: and ppt.payment_type_id = pac.payment_type_id;
1220: else
1221: l_action_name := p_info.action_name;