APPS.HR_EDW_WRK_SPRTN_F_SIZING dependencies on PER_PERIODS_OF_SERVICE

Line 15: FROM per_periods_of_service pps

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

Line 93: FROM per_periods_of_service pps

89: SELECT
90: avg(nvl(vsize(pps.period_of_service_id),0 ))
91: ,avg(nvl(vsize(pps.termination_accepted_person_id),0 ))
92: ,avg(nvl(vsize(pps.leaving_reason),0 ))
93: FROM per_periods_of_service pps
94: WHERE pps.last_update_date BETWEEN p_from_date AND p_to_date;
95:
96: CURSOR pasg_cur IS
97: SELECT