DBA Data[Home] [Help]

APPS.EDW_HR_GRADE_M_SIZING dependencies on PER_GRADES

Line 15: FROM per_grades gra

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

Line 68: FROM per_grades

64: avg(nvl(vsize(sequence),0))
65: ,avg(nvl(vsize(name),0))
66: ,avg(nvl(vsize(grade_id),0))
67: ,avg(nvl(vsize(business_group_id),0))
68: FROM per_grades
69: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
70:
71: CURSOR bus_cur IS
72: SELECT