APPS.PAY_RATES_PKG dependencies on PAY_GRADE_RULES_F

Line 183: DELETE FROM PAY_GRADE_RULES_F

179: IF P_CHILD = 'Y'
180: THEN
181:
182: /* delete any children if they exist */
183: DELETE FROM PAY_GRADE_RULES_F
184: WHERE RATE_ID = P_RATE_ID;
185:
186: END IF;
187:

Line 240: CURSOR C2 IS SELECT * FROM PAY_GRADE_RULES_F WHERE RATE_ID = P_RATE_ID

236:
237: CURSOR C IS SELECT * FROM PAY_RATES WHERE ROWID = P_ROWID
238: FOR UPDATE OF RATE_ID NOWAIT;
239:
240: CURSOR C2 IS SELECT * FROM PAY_GRADE_RULES_F WHERE RATE_ID = P_RATE_ID
241: FOR UPDATE OF GRADE_RULE_ID NOWAIT;
242:
243: RECINFO C%ROWTYPE;
244: BEGIN