DBA Data[Home] [Help]

APPS.JA_JAINMCEN_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 118: ORG_ORGANIZATION_DEFINITIONS

114: CURSOR CUR_SOB_ID(CP_ORGANIZATION_ID IN RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE) IS
115: SELECT
116: SET_OF_BOOKS_ID
117: FROM
118: ORG_ORGANIZATION_DEFINITIONS
119: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
120: AND ROWNUM = 1;
121: CURSOR CUR_RECEIPT_LINE_AMOUNT(CP_TRANSACTION_ID IN RCV_TRANSACTIONS.TRANSACTION_ID%TYPE) IS
122: SELECT

Line 128: V_SOB_ID ORG_ORGANIZATION_DEFINITIONS.SET_OF_BOOKS_ID%TYPE;

124: FROM
125: JAI_RCV_LINES A,
126: RCV_TRANSACTIONS B
127: WHERE A.TRANSACTION_ID = B.TRANSACTION_ID;
128: V_SOB_ID ORG_ORGANIZATION_DEFINITIONS.SET_OF_BOOKS_ID%TYPE;
129: V_PO_FUNC_CONV NUMBER;
130: VAMT1 NUMBER := 0;
131: LN_TOT_ASSESSABLE_VAL NUMBER := 0;
132: BEGIN