DBA Data[Home] [Help]

APPS.PAY_QPQ_API dependencies on FND_SESSIONS

Line 410: from fnd_sessions ses

406: v_argument varchar2(30);
407: --
408: cursor pay_asg is
409: select 'Y'
410: from fnd_sessions ses
411: , per_assignments_f asg
412: where ses.session_id = userenv('SESSIONID')
413: and ses.effective_date between asg.effective_start_date
414: and asg.effective_end_date

Line 3855: from fnd_sessions ses

3851: -- Cursor Definitions
3852: --
3853: cursor csr_eff_date is
3854: select effective_date
3855: from fnd_sessions ses
3856: where ses.session_id = userenv('sessionid');
3857: --
3858: cursor csr_payroll (v_cur_date date) is
3859: select /*+ ORDERED INDEX(asg PER_ASSIGNMENTS_F_PK) */