APPS.EDW_HR_ASSGNMNT_M_SIZING dependencies on PER_ALL_ASSIGNMENTS_F

Line 16: per_all_assignments_f asg

12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(*) total
15: FROM
16: per_all_assignments_f asg
17: /* Generates list of earliest date tracked start dates by assignment */
18: ,(select assignment_id, effective_start_date
19: from per_all_assignments_f asg
20: minus

Line 19: from per_all_assignments_f asg

15: FROM
16: per_all_assignments_f asg
17: /* Generates list of earliest date tracked start dates by assignment */
18: ,(select assignment_id, effective_start_date
19: from per_all_assignments_f asg
20: minus
21: /* Remove any assignment start date which has an earlier start date */
22: select assignment_id, effective_start_date
23: from per_all_assignments_f asg

Line 23: from per_all_assignments_f asg

19: from per_all_assignments_f asg
20: minus
21: /* Remove any assignment start date which has an earlier start date */
22: select assignment_id, effective_start_date
23: from per_all_assignments_f asg
24: where exists (select 1 from per_all_assignments_f asg1
25: where asg1.assignment_id = asg.assignment_id
26: and asg1.effective_start_date < asg.effective_start_date)
27: )asg_start

Line 24: where exists (select 1 from per_all_assignments_f asg1

20: minus
21: /* Remove any assignment start date which has an earlier start date */
22: select assignment_id, effective_start_date
23: from per_all_assignments_f asg
24: where exists (select 1 from per_all_assignments_f asg1
25: where asg1.assignment_id = asg.assignment_id
26: and asg1.effective_start_date < asg.effective_start_date)
27: )asg_start
28: WHERE

Line 117: FROM per_all_assignments_f

113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))
116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))
117: FROM per_all_assignments_f
118: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
119:
120: CURSOR ast_cur IS
121: SELECT