DBA Data[Home] [Help]

APPS.JL_JLBRRCAD_XMLP_PKG dependencies on RA_CUSTOMER_TRX

Line 248: RA_CUSTOMER_TRX CUST

244: FND_NUMBER.CANONICAL_TO_NUMBER(NVL(GLOBAL_ATTRIBUTE7
245: ,'0'))
246: INTO X_INTEREST_TYPE,X_INTEREST_RATE_AMOUNT,X_PERIOD_DAYS,X_INTEREST_FORMULA,X_GRACE_DAYS,X_PENALTY_TYPE,X_PENALTY_RATE_AMOUNT
247: FROM
248: RA_CUSTOMER_TRX CUST
249: WHERE CUST.CUSTOMER_TRX_ID = C_CUSTOMER_TRX_ID;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: NULL;

Line 269: RA_CUSTOMER_TRX CUST,

265: FROM
266: HZ_CUST_ACCT_SITES AD,
267: HZ_LOCATIONS LOC,
268: HZ_PARTY_SITES PST,
269: RA_CUSTOMER_TRX CUST,
270: HZ_CUST_SITE_USES SUS,
271: AR_PAYMENT_SCHEDULES SCH
272: WHERE SCH.PAYMENT_SCHEDULE_ID = C_PAYMENT_SCHEDULE_ID
273: AND CUST.CUSTOMER_TRX_ID = SCH.CUSTOMER_TRX_ID