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 3833: from fnd_sessions ses

3829: -- Cursor Definitions
3830: --
3831: cursor csr_eff_date is
3832: select effective_date
3833: from fnd_sessions ses
3834: where ses.session_id = userenv('sessionid');
3835: --
3836: cursor csr_payroll (v_cur_date date) is
3837: select /*+ ORDERED INDEX(asg PER_ASSIGNMENTS_F_PK) */