APPS.PAY_AU_SOE_PKG dependencies on PAY_PAYROLLS_F

Line 1391: p_payroll_id in pay_payrolls_f.payroll_id%type,

1387: p_payroll_id - Payroll Id
1388: */
1389: FUNCTION get_currency_code
1390: (p_business_group_id in hr_organization_units.business_group_id%type,
1391: p_payroll_id in pay_payrolls_f.payroll_id%type,
1392: p_effective_date in date)
1393: return fnd_currencies.currency_code%type is
1394:
1395: lv_currency_code fnd_currencies.currency_code%type;

Line 1397: Cursor payroll_currency_code(c_payroll_id pay_payrolls_f.payroll_id%type) is

1393: return fnd_currencies.currency_code%type is
1394:
1395: lv_currency_code fnd_currencies.currency_code%type;
1396:
1397: Cursor payroll_currency_code(c_payroll_id pay_payrolls_f.payroll_id%type) is
1398: select popm.currency_code
1399: from pay_payrolls_f ppf,
1400: pay_org_payment_methods_f popm
1401: where ppf.default_payment_method_id = popm.org_payment_method_id

Line 1399: from pay_payrolls_f ppf,

1395: lv_currency_code fnd_currencies.currency_code%type;
1396:
1397: Cursor payroll_currency_code(c_payroll_id pay_payrolls_f.payroll_id%type) is
1398: select popm.currency_code
1399: from pay_payrolls_f ppf,
1400: pay_org_payment_methods_f popm
1401: where ppf.default_payment_method_id = popm.org_payment_method_id
1402: and ppf.payroll_id = c_payroll_id
1403: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date