DBA Data[Home] [Help]

APPS.JL_BR_SPED_PKG dependencies on RA_BATCH_SOURCES

Line 23: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

19: -- Declaration part
20:
21: CURSOR C_BATCH_SOURCE IS
22: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') GLOBAL_ATTRIBUTE5
23: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
24: WHERE T.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
25: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
26:
27: CURSOR C_CUST_EXT IS

Line 78: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

74: PROCEDURE Set_Trx_Lock_Status(p_customer_trx_id IN NUMBER) IS
75:
76: CURSOR C_BATCH_SOURCE IS
77: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') GLOBAL_ATTRIBUTE5
78: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
79: WHERE T.CUSTOMER_TRX_ID = p_customer_trx_id
80: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
81: l_country_code varchar2(30);
82: BEGIN