APPS.PQH_GSP_RATES dependencies on PAY_GRADE_RULES_F

Line 1203: from pay_grade_rules_f

1199: p_grade_id in number) is
1200: cursor csr_grd_rate is
1201: select EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, BUSINESS_GROUP_ID,
1202: RATE_ID, MAXIMUM, MID_VALUE, MINIMUM,VALUE, OBJECT_VERSION_NUMBER
1203: from pay_grade_rules_f
1204: where grade_rule_id = p_pay_rule_id
1205: and rate_type ='G'
1206: and GRADE_OR_SPINAL_POINT_ID = p_grade_id
1207: order by effective_start_date;

Line 1297: from pay_grade_rules_f

1293: p_point_id in number) is
1294: cursor csr_point_rate is
1295: select EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, BUSINESS_GROUP_ID,
1296: RATE_ID,VALUE, OBJECT_VERSION_NUMBER
1297: from pay_grade_rules_f
1298: where grade_rule_id = p_pay_rule_id
1299: and rate_type ='SP'
1300: and GRADE_OR_SPINAL_POINT_ID = p_point_id
1301: order by effective_start_date;

Line 2119: from pay_grade_rules_f

2115:
2116: Cursor csr_grd_db_values(p_grade_rule_id in number,p_effective_start_date in date)
2117: Is
2118: select value,minimum,maximum,mid_value
2119: from pay_grade_rules_f
2120: where grade_rule_id = p_grade_rule_id
2121: and effective_start_date = p_effective_start_date;
2122:
2123: Cursor csr_Points

Line 2150: from pay_grade_rules_f

2146:
2147: Cursor csr_pnt_db_values(p_grade_rule_id in number,p_effective_start_date in date)
2148: Is
2149: select value
2150: from pay_grade_rules_f
2151: where grade_rule_id = p_grade_rule_id
2152: and effective_start_date = p_effective_start_date;
2153:
2154: Cursor csr_gsp_task_list is