APPS.XDP_PURGE dependencies on XNP_SV_STATUS_TYPES_B

Line 311: FOR l_sv_soa IN (SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B

307: FND_MESSAGE.SET_TOKEN('CONDITION','XDP_CHECK_SOA');
308: PURGE_ERRORS(FND_MESSAGE.GET);
309: END IF;
310:
311: FOR l_sv_soa IN (SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B
312: WHERE a.STATUS_TYPE_CODE = b.STATUS_TYPE_CODE
313: AND b.PHASE_INDICATOR ='OLD'
314: AND a.MODIFIED_DATE < p_time_to
315: AND a.MODIFIED_DATE > p_time_from)

Line 1207: SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B

1203: p_run_mode IN VARCHAR2 DEFAULT 'VERIFY',
1204: p_rollback_segment IN VARCHAR2 DEFAULT NULL
1205: ) IS
1206: CURSOR c_xnp_soa(p_time_from IN DATE,p_time_to IN DATE) IS
1207: SELECT SV_SOA_ID FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B
1208: WHERE a.STATUS_TYPE_CODE = b.STATUS_TYPE_CODE
1209: AND b.PHASE_INDICATOR ='OLD'
1210: AND a.MODIFIED_DATE < p_time_to
1211: AND a.MODIFIED_DATE > p_time_from FOR UPDATE OF A.SV_SOA_ID NOWAIT;

Line 1232: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B

1228: l_rec_name := 'XDP_PURGE_REC';
1229: END IF;
1230:
1231: IF p_run_mode ='CHECK' THEN
1232: SELECT COUNT(*) INTO l_temp FROM XNP_SV_SOA A, XNP_SV_STATUS_TYPES_B B
1233: WHERE a.STATUS_TYPE_CODE = b.STATUS_TYPE_CODE
1234: AND b.PHASE_INDICATOR ='OLD'
1235: AND a.MODIFIED_DATE < p_time_to
1236: AND a.MODIFIED_DATE > p_time_from;