APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 146: from per_all_assignments_f

142: c_effective_end_date) effective_end_date
143: ,location_id
144: ,business_group_id --ENH8
145: ,NVL(employment_category,'FT') asg_emp_cat_cd --ENH3
146: from per_all_assignments_f
147: where assignment_id = c_assignment_id
148: and (effective_start_date between c_effective_start_date
149: and c_effective_end_date
150: or

Line 269: FROM per_all_assignments_f asg

265: ,asg.business_group_id business_group_id
266: ,DECODE(asg.business_group_id
267: ,g_business_group_id, 0
268: ,asg.business_group_id) bizgrpcol
269: FROM per_all_assignments_f asg
270: WHERE asg.person_id = p_person_id
271: AND asg.assignment_id <> p_primary_assignment_id
272: AND ((p_effective_date BETWEEN asg.effective_start_date
273: AND asg.effective_end_date

Line 291: FROM per_all_people_f per, per_all_assignments_f asg

287: ,asg.business_group_id business_group_id
288: ,DECODE(asg.business_group_id
289: ,g_business_group_id, 0
290: ,asg.business_group_id) bizgrpcol
291: FROM per_all_people_f per, per_all_assignments_f asg
292: WHERE per.person_id <> p_person_id
293: AND p_effective_date BETWEEN per.effective_start_date
294: AND per.effective_end_date
295: AND g_cross_per_enabled = 'Y' -- Cross Person is enabled

Line 335: FROM per_all_assignments_f

331: c_assignment_id IN NUMBER
332: )
333: IS
334: SELECT person_id,business_group_id
335: FROM per_all_assignments_f
336: WHERE assignment_id = c_assignment_id
337: AND ROWNUM < 2;
338:
339: --ENH3 AND ENH4

Line 348: FROM per_all_assignments_f asg

344: ,c_start_date IN DATE
345: )
346: IS
347: SELECT NVL(asg.employment_category,'FT') asg_emp_cat_cd
348: FROM per_all_assignments_f asg
349: WHERE asg.assignment_id = c_assignment_id
350: AND ( c_start_date BETWEEN asg.effective_start_date
351: AND asg.effective_end_date )
352: ORDER BY asg.effective_start_date DESC; -- effective row first