DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_PAYMENT_TYPES

Line 502: pay_payment_types ppt,

498: procedure reset_prenote(p_assact_id in number) is
499: cursor get_accnts_to_reset(asgact in number) is
500: select pea.external_account_id
501: from pay_external_accounts pea,
502: pay_payment_types ppt,
503: pay_personal_payment_methods_f ppm,
504: pay_org_payment_methods_f opm,
505: pay_pre_payments ppp,
506: pay_payroll_actions ppa,

Line 1212: pay_payment_types ppt

1208: end if;
1209: select ppt.payment_type_name
1210: into l_action_name
1211: from pay_payroll_actions pac,
1212: pay_payment_types ppt
1213: where pac.payroll_action_id = p_info.pact_id
1214: and ppt.payment_type_id = pac.payment_type_id;
1215: else
1216: l_action_name := p_info.action_name;