APPS.JL_JLZZRCVI_XMLP_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 829: RA_CUSTOMER_TRX_ALL

825: SELECT
826: MAX(DOC_SEQUENCE_VALUE)
827: INTO L_MAX_DOC_SEQ_NUM
828: FROM
829: RA_CUSTOMER_TRX_ALL
830: WHERE DOC_SEQUENCE_VALUE <= TO_NUMBER(P_NUMBER_HIGH);
831: IF L_MAX_DOC_SEQ_NUM < P_NUMBER_HIGH THEN
832: CP_ORIG_INV_NOT_FOUND_MESG := L_MAX_DOC_SEQ_NUM;
833: RETURN (TRUE);

Line 842: RA_CUSTOMER_TRX_ALL

838: SELECT
839: MAX(TRX_NUMBER)
840: INTO L_MAX_TRX_NUM
841: FROM
842: RA_CUSTOMER_TRX_ALL
843: WHERE TRX_NUMBER <= P_NUMBER_HIGH;
844: IF L_MAX_TRX_NUM < P_NUMBER_HIGH THEN
845: CP_ORIG_INV_NOT_FOUND_MESG := L_MAX_TRX_NUM;
846: RETURN (TRUE);