eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_PAYPROC_UTILITY dependencies on PAY_PAYROLLS_F

Line 14: from pay_payrolls_f paf

10:
11: cursor csr_payment_method_id
12: is
13: select paf.DEFAULT_PAYMENT_METHOD_ID
14: from pay_payrolls_f paf
15: where paf.payroll_id = p_payroll_id
16: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
17:
18: l_payment_method_id pay_payrolls_f.DEFAULT_PAYMENT_METHOD_ID%TYPE;

Line 18: l_payment_method_id pay_payrolls_f.DEFAULT_PAYMENT_METHOD_ID%TYPE;

14: from pay_payrolls_f paf
15: where paf.payroll_id = p_payroll_id
16: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
17:
18: l_payment_method_id pay_payrolls_f.DEFAULT_PAYMENT_METHOD_ID%TYPE;
19:
20: begin
21:
22: open csr_payment_method_id;

Line 47: from pay_payrolls_f paf

43:
44: cursor csr_payment_method_id
45: is
46: select paf.DEFAULT_PAYMENT_METHOD_ID
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;

Line 52: l_personal_method_id pay_payrolls_f.DEFAULT_PAYMENT_METHOD_ID%TYPE;

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:
56: