APPS.PN_EXP_PAYMENT_ITEMS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 39: FROM PN_PAYMENT_SCHEDULES_ALL

35: FOR UPDATE OF PAYMENT_ITEM_ID NOWAIT;
36:
37: CURSOR c2 IS
38: SELECT PERIOD_NAME
39: FROM PN_PAYMENT_SCHEDULES_ALL
40: WHERE PAYMENT_SCHEDULE_ID = X_PAYMENT_SCHEDULE_ID
41: FOR UPDATE OF PAYMENT_SCHEDULE_ID NOWAIT;
42:
43: tlinfo c1%ROWTYPE;

Line 187: UPDATE PN_PAYMENT_SCHEDULES_ALL

183: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
184: WHERE PAYMENT_ITEM_ID = X_PAYMENT_ITEM_ID;
185:
186: l_info_text := 'updating associated payment schedule';
187: UPDATE PN_PAYMENT_SCHEDULES_ALL
188: SET PERIOD_NAME = X_PERIOD_NAME
189: WHERE PAYMENT_SCHEDULE_ID = X_PAYMENT_SCHEDULE_ID;
190:
191: IF (SQL%NOTFOUND) THEN