APPS.IEX_PROMISES_BATCH_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 147: IEX_DELINQUENCIES_ALL DEL

143: SELECT
144: PRD.PROMISE_DETAIL_ID
145: FROM
146: IEX_PROMISE_DETAILS PRD,
147: IEX_DELINQUENCIES_ALL DEL
148: WHERE
149: DEL.DELINQUENCY_ID = PRD.DELINQUENCY_ID AND
150: DEL.CUST_ACCOUNT_ID = PRD.CUST_ACCOUNT_ID AND
151: DEL.PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID AND

Line 1013: update iex_delinquencies_all

1009: LOOP
1010:
1011: iex_utilities.MaxStageForanDelinquency (p_delinquency_id => I.delinquency_id
1012: , p_stage_number => l_stage_number);
1013: update iex_delinquencies_all
1014: set staged_dunning_level = l_stage_number
1015: where delinquency_id = I.delinquency_id;
1016: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1017: LogMessage(G_PKG_NAME || '.' || l_api_name || 'Updated the staged dunning level to ' || l_stage_number || ' for delinquency id: ' || I.delinquency_id);

Line 1025: update iex_delinquencies_all

1021:
1022: FOR J IN UPDATE_FULLY_PRO_DEL
1023: LOOP
1024:
1025: update iex_delinquencies_all
1026: set staged_dunning_level = 0
1027: where delinquency_id = J.delinquency_id;
1028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1029: LogMessage(G_PKG_NAME || '.' || l_api_name || 'Updated the staged dunning level to 0 for delinquency id: ' || J.delinquency_id);