APPS.HXC_RDB_POST_RETRIEVAL dependencies on PER_ASSIGNMENTS_F

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

79:
80: -- Bug 12605349: Used secure views where ever needed to add HR security
81: l_payroll_criteria VARCHAR2(2000) :=
82: 'AND EXISTS ( SELECT 1
83: FROM per_assignments_f paf /*Bug 12605349*/
84: WHERE paf.person_id = ret.resource_id
85: AND ret.start_time BETWEEN paf.effective_start_date
86: AND paf.effective_end_date
87: AND paf.payroll_id = PAYROLL )'

Line 94: FROM per_assignments_f paf /*Bug 9656063*/

90: -- Bug 9656063
91:
92: l_org_criteria VARCHAR2(2000) :=
93: 'AND EXISTS ( SELECT 1
94: FROM per_assignments_f paf /*Bug 9656063*/
95: WHERE paf.person_id = ret.resource_id
96: AND ret.start_time BETWEEN paf.effective_start_date
97: AND paf.effective_end_date
98: AND paf.organization_id = ORGANIZATION )'

Line 314: per_assignments_f asg -- Bug 12605349

310: asg.organization_id,
311: asg.job_id,
312: ROWIDTOCHAR(tc.ROWID)
313: FROM hxc_rdb_post_timecards tc,
314: per_assignments_f asg -- Bug 12605349
315: WHERE tc.ret_user_id = FND_GLOBAL.user_id
316: AND tc.resource_id = asg.person_id
317: AND tc.start_time BETWEEN asg.effective_start_date
318: AND asg.effective_end_date;