DBA Data[Home] [Help]

APPS.HXC_RDB_PRE_RETRIEVAL dependencies on PER_ASSIGNMENTS_F

Line 76: FROM per_assignments_f paf /*Bug 12605349*/

72:
73:
74: l_pay_asg VARCHAR2(3000) :=
75: 'AND EXISTS ( SELECT 1
76: FROM per_assignments_f paf /*Bug 12605349*/
77: WHERE paf.person_id = ret.resource_id
78: AND ret.start_time BETWEEN paf.effective_start_date
79: AND paf.effective_end_date
80: PAYROLLCRITERIA

Line 151: per_assignments_f paf -- Bug 12605349

147: CURSOR get_supervisor
148: IS SELECT paf.supervisor_id,
149: ROWIDTOCHAR(tc.rowid)
150: FROM hxc_rdb_pre_timecards tc,
151: per_assignments_f paf -- Bug 12605349
152: WHERE tc.ret_user_id = FND_GLOBAL.user_id
153: AND tc.resource_id = paf.person_id
154: AND tc.start_time BETWEEN paf.effective_start_date
155: AND paf.effective_end_date;