DBA Data[Home] [Help]

APPS.PAY_SG_SOE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1026: pay_org_payment_methods_f popm

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
1030: and c_effective_date between popm.effective_start_date and popm.effective_end_date;