APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_GRADE_SPINES

Line 1058: FROM PER_GRADE_SPINES pgs,PER_SPINAL_POINT_STEPS psp

1054: ORDER BY grade_rule_id;
1055: --
1056: Cursor Cpay is
1057: SELECT pgs.grade_id,pgs.grade_spine_id,psp.step_id,psp.sequence
1058: FROM PER_GRADE_SPINES pgs,PER_SPINAL_POINT_STEPS psp
1059: WHERE pgs.parent_spine_id = l_parent_spine_id
1060: AND pgs.business_group_id = p_business_group_id
1061: AND psp.business_group_id = p_business_group_id
1062: AND pgs.grade_spine_id = psp.grade_spine_id

Line 1770: FROM per_grade_spines pgs, per_parent_spines pps

1766:
1767: Cursor C_grade is
1768: SELECT pgs.grade_id,pgs.parent_spine_id,
1769: pps.name
1770: FROM per_grade_spines pgs, per_parent_spines pps
1771: WHERE grade_spine_id = l_grade_spine_id
1772: and pgs.parent_spine_id = pps.parent_spine_id;
1773:
1774: /* Commented out and changed to enhance performance 23-NOV-2002*/

Line 1998: -- Getting Grade_id from per_grade_spines

1994: l_session_date,
1995: l_spinal_point_id,
1996: l_grade_spine_id);
1997:
1998: -- Getting Grade_id from per_grade_spines
1999: For C_grade_rec in C_grade
2000: Loop
2001: l_grade_id := C_grade_rec.grade_id;
2002: l_parent_spine_id := C_grade_rec.parent_spine_id;