APPS.HR_EDW_WRK_ACTVTY_F_SIZING dependencies on PER_ALL_ASSIGNMENTS_F

Line 15: FROM per_all_assignments_f asg

11:
12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(asg.assignment_id) total
15: FROM per_all_assignments_f asg
16: WHERE NVL(asg.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
17: BETWEEN p_from_date AND p_to_date;
18:
19: BEGIN

Line 199: FROM per_all_assignments_f asg

195: ,avg(nvl(vsize(asg.collective_agreement_id),0))
196: ,avg(nvl(vsize(asg.cagr_id_flex_num),0))
197: ,avg(nvl(vsize(asg.cagr_grade_def_id),0))
198: ,avg(nvl(vsize(asg.establishment_id),0))
199: FROM per_all_assignments_f asg
200: WHERE asg.last_update_date BETWEEN p_from_date AND p_to_date;
201:
202: BEGIN
203: