DBA Data[Home] [Help]

APPS.PY_ZA_TX dependencies on FND_SESSIONS

Line 654: fnd_sessions fnd

650:
651: cursor c1 (c_assignment_id NUMBER) is
652: SELECT per.effective_start_date, per.effective_end_date
653: FROM per_assignments_f per,
654: fnd_sessions fnd
655: WHERE per.assignment_id = c_assignment_id
656: AND fnd.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
657: AND fnd.session_id = USERENV('sessionid');
658:

Line 755: fnd_sessions fnd

751:
752: cursor c1 (c_assignment_id NUMBER) is
753: SELECT per.effective_start_date
754: FROM per_assignments_f per,
755: fnd_sessions fnd
756: WHERE per.assignment_id = c_assignment_id
757: AND fnd.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
758: AND fnd.session_id = USERENV('sessionid');
759: