APPS.PAY_NO_PAYPROC_UTILITY dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 40: from pay_personal_payment_methods_f ppm

36:
37: cursor csr_payment
38: is
39: select ppm.external_account_id
40: from pay_personal_payment_methods_f ppm
41: where ppm.personal_payment_method_id=p_personal_method_id
42: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
43:
44: cursor csr_payment_method_id

Line 51: l_payment pay_personal_payment_methods_f.external_account_id%TYPE;

47: from pay_payrolls_f paf
48: where paf.payroll_id = p_payroll_id
49: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
50:
51: l_payment pay_personal_payment_methods_f.external_account_id%TYPE;
52: l_personal_method_id pay_payrolls_f.DEFAULT_PAYMENT_METHOD_ID%TYPE;
53: l_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
54:
55:

Line 53: l_account_id pay_personal_payment_methods_f.external_account_id%TYPE;

49: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
50:
51: l_payment pay_personal_payment_methods_f.external_account_id%TYPE;
52: l_personal_method_id pay_payrolls_f.DEFAULT_PAYMENT_METHOD_ID%TYPE;
53: l_account_id pay_personal_payment_methods_f.external_account_id%TYPE;
54:
55:
56:
57: begin

Line 71: from pay_personal_payment_methods_f ppm

67: fetch csr_payment_method_id into l_personal_method_id;
68: close csr_payment_method_id;
69:
70: select ppm.external_account_id into l_account_id
71: from pay_personal_payment_methods_f ppm
72: where ppm.personal_payment_method_id=l_personal_method_id
73: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
74:
75: RETURN l_account_id;

Line 91: from pay_personal_payment_methods_f ppm

87:
88: cursor csr_payment
89: is
90: select ppm.external_account_id
91: from pay_personal_payment_methods_f ppm
92: where ppm.personal_payment_method_id=p_personal_method_id
93: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
94:
95:

Line 96: l_payment pay_personal_payment_methods_f.external_account_id%TYPE;

92: where ppm.personal_payment_method_id=p_personal_method_id
93: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
94:
95:
96: l_payment pay_personal_payment_methods_f.external_account_id%TYPE;
97:
98:
99: begin
100: