APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PAY_RATES

Line 351: from pay_rates

347: order by segment_num;
348:
349: Cursor C_rate_check is
350: Select count(*), parent_spine_id
351: from pay_rates
352: where business_group_id = p_business_group_id
353: -- Start bug no 3902996
354: and parent_spine_id = l_parent_spine_id
355: -- End bug no 3902996

Line 1079: FROM PAY_RATES pr, PER_PAY_BASES ppb, PAY_INPUT_VALUES piv

1075: AND business_group_id = p_business_group_id;
1076: --
1077: Cursor C_paybasis is
1078: SELECT pay_basis, piv.element_type_id
1079: FROM PAY_RATES pr, PER_PAY_BASES ppb, PAY_INPUT_VALUES piv
1080: WHERE pr.parent_spine_id = l_rate_or_payscale_id
1081: AND pr.rate_id = ppb.rate_id
1082: AND pr.business_group_id = p_business_group_id
1083: AND ppb.business_group_id = p_business_group_id

Line 1098: FROM PAY_RATES

1094: WHERE session_id = USERENV('sessionid');
1095: --
1096: Cursor C_rate is
1097: SELECT name
1098: FROM PAY_RATES
1099: WHERE rate_id = l_rate_id;
1100:
1101: -- To fetch grade name from PER_GRADES
1102: -- (Bug Number 3159157)

Line 1118: from pay_rates

1114: AND ppb.input_value_id = piv.input_value_id;
1115: --
1116: Cursor C_rate_check is
1117: Select count(*), parent_spine_id
1118: from pay_rates
1119: where business_group_id = p_business_group_id
1120: -- Start bug no 3902996
1121: and parent_spine_id = l_parent_spine_id
1122: -- End bug no 3902996

Line 1258: -- To get Grade Rate Name from pay_rates

1254: if (l_rate_cnt_flag = 'Y') then
1255:
1256: l_rate_or_payscale_id := salary_rec.rate_id;
1257:
1258: -- To get Grade Rate Name from pay_rates
1259: For C_rate_rec in C_rate
1260: Loop
1261: l_rate_or_payscale_name := C_rate_rec.name;
1262:

Line 1391: -- To get Grade Rate Name from pay_rates

1387:
1388: l_grade_id := salary_rec.grade_or_spinal_point_id;
1389: l_rate_or_payscale_id := salary_rec.rate_id;
1390:
1391: -- To get Grade Rate Name from pay_rates
1392: For C_rate_rec in C_rate
1393: Loop
1394: l_rate_or_payscale_name := C_rate_rec.name;
1395:

Line 1652: from pay_rates

1648: l_assign_stat_cnt number := 0;
1649:
1650: Cursor C_rate_check is
1651: Select count(*), parent_spine_id
1652: from pay_rates
1653: where business_group_id = p_business_group_id
1654: -- Start bug no 3902996
1655: and parent_spine_id = l_parent_spine_id
1656: -- End bug no 3902996