DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on FND_SESSIONS

Line 3764: fnd_sessions fs

3760:
3761: SELECT period_type
3762: INTO lv_period_type
3763: FROM pay_all_payrolls_f ppf,
3764: fnd_sessions fs
3765: WHERE payroll_id = p_payroll_id
3766: AND fs.effective_date BETWEEN ppf.effective_start_date
3767: AND ppf.effective_end_date
3768: AND fs.session_id = USERENV('sessionid');

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

4482: hr_utility_trace('p_period_days: ' ||p_period_days);
4483: hr_utility_trace('p_period_number: ' ||p_period_number);
4484: hr_utility_trace('p_period_type: ' ||p_period_type);
4485: --
4486: -- Use either the supplied date, or the date from fnd_sessions
4487: --
4488: if (p_effective_date is not null) then
4489: l_effective_date := p_effective_date;
4490: end if;