APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PAY_EXTERNAL_ACCOUNTS

Line 301: from pay_external_accounts exa

297: cursor csr_curr_prenote_date
298: (p_external_account_id in number
299: ) is
300: select exa.prenote_date
301: from pay_external_accounts exa
302: where exa.external_account_id = p_external_account_id
303: ;
304: begin
305: if g_debug then

Line 401: -- the prenote_date already present in pay_external_accounts

397: close csr_curr_prenote_date;
398: --
399: -- For bug 9766116
400: -- If the newly calculated prenote_date is less than
401: -- the prenote_date already present in pay_external_accounts
402: -- then updating the prenote_date with the new value
403: if l_prenote_date is null OR ( l_new_prenote_date < l_prenote_date )then
404: if g_debug then
405: hr_utility.set_location('Stamp the prenote date:'|| l_proc, 40);

Line 428: -- This procedure is used to update the prenote date in pay_external_accounts

424: --
425: -- {Start Of Comments}
426: --
427: -- Description:
428: -- This procedure is used to update the prenote date in pay_external_accounts
429: -- with the value provided by the user. However the prenote date is updated
430: -- only if prenoting is allowed for the payroll(ie. prl_information3 = 'Y').
431: --
432: -- Prerequisites:

Line 464: l_exa_ovn pay_external_accounts.object_version_number%type;

460: ,p_prenote_date in date
461: ) is
462: --
463: l_proc varchar2(72) := 'upd_prenote_date';
464: l_exa_ovn pay_external_accounts.object_version_number%type;
465: l_prenote_allowed pay_all_payrolls_f.prl_information3%type;
466: --
467: cursor csr_payroll_details(p_personal_payment_method_id in number
468: ,p_effective_date in date

Line 486: from pay_external_accounts pea

482: pap.effective_start_date and pap.effective_end_date;
483: --
484: cursor csr_exa_ovn(p_external_account_id in number) is
485: select pea.object_version_number
486: from pay_external_accounts pea
487: where pea.external_account_id = p_external_account_id;
488: --
489: begin
490: --

Line 2104: pay_external_accounts.object_version_number%TYPE;

2100: l_validate boolean := FALSE;
2101: l_external_account_id
2102: pay_personal_payment_methods_f.external_account_id%TYPE;
2103: l_object_version_number
2104: pay_external_accounts.object_version_number%TYPE;
2105: l_exa_ovn number;
2106: l_effective_date date;
2107: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
2108: --

Line 2132: from pay_external_accounts pea

2128: --
2129: cursor ovnsel is
2130: select pea.object_version_number
2131: , pea.territory_code
2132: from pay_external_accounts pea
2133: where pea.external_account_id = l_external_account_id;
2134: --
2135: cursor csr_chk_pay_type is
2136: select pyt.category