DBA Data[Home] [Help]

APPS.PER_SPINAL_PT_PLCMT_PKG dependencies on PER_ASSIGNMENTS_F

Line 11: from per_assignments_f a

7: l_exists VARCHAR2(1);
8:
9: cursor c20 is
10: select 'x'
11: from per_assignments_f a
12: where a.assignment_id = p_ass_id
13: and a.effective_start_date >= p_sess
14: and a.grade_id <> p_grd_id;
15: --

Line 637: from per_assignments_f asg,

633: --
634: cursor c_derive_info is
635: select asg.business_group_id,
636: ses.effective_date
637: from per_assignments_f asg,
638: fnd_sessions ses
639: where asg.assignment_id = p_ass_id
640: and ses.session_id = userenv('SESSIONID')
641: and ses.effective_date between