DBA Data[Home] [Help]

APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT dependencies on AHL_MR_ROUTE_SEQUENCES_APP_V

Line 118: FROM AHL_MR_ROUTE_SEQUENCES_APP_V

114: ATTRIBUTE12,
115: ATTRIBUTE13,
116: ATTRIBUTE14,
117: ATTRIBUTE15
118: FROM AHL_MR_ROUTE_SEQUENCES_APP_V
119: Where MR_ROUTE_SEQUENCE_ID=c_MR_ROUTE_SEQUENCE_ID;
120:
121: l_routeseq_rec CurGetSeqDet%rowtype;
122:

Line 339: From AHL_MR_ROUTE_SEQUENCES_APP_V

335:
336: CURSOR CHECK_UNIQ(C_MR_ROUTE_ID NUMBER,C_RELATED_MR_ROUTE_ID NUMBER,C_SEQUENCE_CODE VARCHAR2)
337: IS
338: Select MR_ROUTE_SEQUENCE_ID
339: From AHL_MR_ROUTE_SEQUENCES_APP_V
340: Where MR_ROUTE_ID=C_MR_ROUTE_ID
341: And RELATED_MR_ROUTE_ID=C_RELATED_MR_ROUTE_ID
342: And SEQUENCE_CODE=C_SEQUENCE_CODE;
343:

Line 518: From AHL_MR_ROUTE_SEQUENCES_APP_V

514:
515: CURSOR CHECK_UNIQ(C_MR_ROUTE_ID NUMBER,C_RELATED_MR_ROUTE_ID NUMBER,C_SEQUENCE_CODE VARCHAR2)
516: IS
517: Select count(*)
518: From AHL_MR_ROUTE_SEQUENCES_APP_V
519: Where MR_ROUTE_ID=C_MR_ROUTE_ID
520: And RELATED_MR_ROUTE_ID=C_RELATED_MR_ROUTE_ID
521: And SEQUENCE_CODE=C_SEQUENCE_CODE;
522: