APPS.JL_JLBRRCAD_XMLP_PKG dependencies on JL_BR_AR_COLLECTION_DOCS

Line 339: JL_BR_AR_COLLECTION_DOCS DOCS

335: FLV.MEANING
336: INTO X_DOCUMENT_STATUS
337: FROM
338: FND_LOOKUPS FLV,
339: JL_BR_AR_COLLECTION_DOCS DOCS
340: WHERE DOCS.PAYMENT_SCHEDULE_ID = C_PAYMENT_SCHEDULE_ID
341: AND FLV.LOOKUP_CODE = DOCS.DOCUMENT_STATUS
342: AND FLV.LOOKUP_TYPE = 'JLBR_AR_COLLECTION_DOCS_STATUS'
343: AND NVL(DOCS.DOCUMENT_STATUS

Line 364: JL_BR_AR_COLLECTION_DOCS DOCS

360: SELECT
361: DOCS.BORDERO_ID
362: INTO X_BORDERO_NUMBER
363: FROM
364: JL_BR_AR_COLLECTION_DOCS DOCS
365: WHERE DOCS.PAYMENT_SCHEDULE_ID = C_PAYMENT_SCHEDULE_ID
366: AND NVL(DOCS.DOCUMENT_STATUS
367: ,'-') not in ( 'CANCELED' , 'REFUSED' , 'PARTIALLY_RECEIVED' , 'WRITTEN_OFF' );
368: EXCEPTION

Line 387: JL_BR_AR_COLLECTION_DOCS DOCS,

383: SELECT
384: BOR.SELECTION_CONTROL_ID
385: INTO X_SELECTION_NUMBER
386: FROM
387: JL_BR_AR_COLLECTION_DOCS DOCS,
388: JL_BR_AR_BORDEROS BOR
389: WHERE DOCS.PAYMENT_SCHEDULE_ID = C_PAYMENT_SCHEDULE_ID
390: AND BOR.BORDERO_ID = DOCS.BORDERO_ID
391: AND NVL(DOCS.DOCUMENT_STATUS