APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_PARENT_SPINES

Line 1073: FROM PER_PARENT_SPINES

1069: AND business_group_id = p_business_group_id;
1070: --
1071: Cursor C_payname is
1072: SELECT name
1073: FROM PER_PARENT_SPINES
1074: WHERE parent_spine_id = l_rate_or_payscale_id
1075: AND business_group_id = p_business_group_id;
1076: --
1077: Cursor C_paybasis is

Line 1281: -- To get payscale_name from Per_Parent_Spines.

1277: else
1278: l_rate_or_payscale_id := l_parent_spine_id;
1279:
1280:
1281: -- To get payscale_name from Per_Parent_Spines.
1282: For C_payname_rec in C_payname
1283: Loop
1284: l_rate_or_payscale_name := C_payname_rec.name;
1285: End Loop;

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*/