APPS.JA_JAINARDR_XMLP_PKG dependencies on GL_CODE_COMBINATIONS

Line 44: GL_CODE_COMBINATIONS E

40: FROM
41: AR_ADJUSTMENTS_ALL B,
42: RA_CUSTOMER_TRX_ALL C,
43: AR_PAYMENT_SCHEDULES_ALL D,
44: GL_CODE_COMBINATIONS E
45: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
46: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
47: AND E.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID
48: AND TRUNC(B.GL_DATE) < TRUNC(P_START_DATE)

Line 330: GL_CODE_COMBINATIONS E

326: FROM
327: AR_ADJUSTMENTS_ALL B,
328: RA_CUSTOMER_TRX_ALL C,
329: AR_PAYMENT_SCHEDULES_ALL D,
330: GL_CODE_COMBINATIONS E
331: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
332: AND E.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID
333: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
334: AND TRUNC(B.GL_DATE) <= TRUNC(P_END_DATE)

Line 806: 'select ' || V_COLUMN_NAME || ' from gl_code_combinations

802: FETCH FLEX_VAL_SET_ID
803: INTO V_FLEX_ID;
804: CLOSE FLEX_VAL_SET_ID;
805: EXECUTE IMMEDIATE
806: 'select ' || V_COLUMN_NAME || ' from gl_code_combinations
807: where chart_of_accounts_id = :P_CHART_OF_ACCOUNTS_ID AND code_combination_id = :account_id'
808: INTO p_column_value
809: USING P_CHART_OF_ACCOUNTS_ID,account_id ;
810: V_COLUMN_VALUE := P_COLUMN_VALUE;