DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on FND_SESSIONS

Line 2466: fnd_sessions fs

2462:
2463: SELECT period_type
2464: INTO lv_period_type
2465: FROM pay_all_payrolls_f ppf,
2466: fnd_sessions fs
2467: WHERE payroll_id = p_payroll_id
2468: AND fs.effective_date BETWEEN ppf.effective_start_date
2469: AND ppf.effective_end_date
2470: AND fs.session_id = USERENV('sessionid');

Line 3034: -- Use either the supplied date, or the date from fnd_sessions

3030: hr_utility_trace('p_period_days: ' ||p_period_days);
3031: hr_utility_trace('p_period_number: ' ||p_period_number);
3032: hr_utility_trace('p_period_type: ' ||p_period_type);
3033: --
3034: -- Use either the supplied date, or the date from fnd_sessions
3035: --
3036: if (p_effective_date is not null) then
3037: l_effective_date := p_effective_date;
3038: end if;