APPS.EDW_HR_REC_ACT_M_SIZING dependencies on PER_RECRUITMENT_ACTIVITIES

Line 15: FROM per_recruitment_activities

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

Line 84: FROM per_recruitment_activities

80: ,avg(nvl(vsize(business_group_id),0))
81: ,avg(nvl(vsize(recruitment_activity_id),0))
82: ,avg(nvl(vsize(actual_cost),0))
83: ,avg(nvl(vsize(planned_cost),0))
84: FROM per_recruitment_activities
85: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
86:
87: CURSOR bus_cur IS
88: SELECT avg(nvl(vsize(name),0))