APPS.PAY_SG_SOE dependencies on PAY_PAYROLLS_F

Line 1015: (p_payroll_id in pay_payrolls_f.payroll_id%type,

1011: -- Bug#5633652 - Returns currency code based on the payment method attached
1012: -- to a payroll
1013: ------------------------------------------------------------------------
1014: function get_payroll_currency_code
1015: (p_payroll_id in pay_payrolls_f.payroll_id%type,
1016: p_effective_date in pay_payroll_actions.effective_date%type)
1017: return fnd_currencies.currency_code%type is
1018:
1019: v_currency_code fnd_currencies.currency_code%type;

Line 1025: from pay_payrolls_f ppf,

1021: cursor csr_currency_code
1022: (c_payroll_id pay_assignment_actions.assignment_action_id%type,
1023: c_effective_date in pay_payroll_actions.effective_date%type) is
1024: select popm.currency_code
1025: from pay_payrolls_f ppf,
1026: pay_org_payment_methods_f popm
1027: where ppf.payroll_id = c_payroll_id
1028: and popm.org_payment_method_id = ppf.default_payment_method_id
1029: and c_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 1052: v_payroll_id pay_payrolls_f.payroll_id%type;

1048: p_effective_date in pay_payroll_actions.effective_date%type)
1049: return fnd_currencies.currency_code%type is
1050:
1051: v_currency_code fnd_currencies.currency_code%type;
1052: v_payroll_id pay_payrolls_f.payroll_id%type;
1053:
1054: cursor csr_get_payroll_id
1055: (c_assignment_id pay_assignment_actions.assignment_action_id%type,
1056: c_effective_date in pay_payroll_actions.effective_date%type) is