APPS.EDW_HR_PRSN_TYP_M_SIZING dependencies on HRI_PERSON_TYPE_CMBNS

Line 15: FROM hri_person_type_cmbns

11:
12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(person_type_pk) total
15: FROM hri_person_type_cmbns
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: BEGIN

Line 102: FROM hri_person_type_cmbns

98: ,avg(nvl(vsize(other),0))
99: ,avg(nvl(vsize(participant),0))
100: ,avg(nvl(vsize(former_spouse),0))
101: ,avg(nvl(vsize(former_family_member),0))
102: FROM hri_person_type_cmbns
103: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
104:
105: CURSOR yes_no_cur IS
106: SELECT