APPS.JL_BR_SPED_PKG dependencies on RA_BATCH_SOURCES

Line 22: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

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

Line 77: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

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

Line 428: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

424: FND_PROFILE.GET('JGZZ_COUNTRY_CODE', L_COUNTRY_CODE);
425:
426: BEGIN
427: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') INTO L_ISSUE_AUTHORITY
428: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
429: WHERE T.REQUEST_ID = P_REQUEST_ID
430: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID
431: AND ROWNUM = 1;
432: EXCEPTION

Line 1112: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

1108: FOR I IN 1..CUSTOMER_TRX_ID.COUNT
1109: LOOP
1110: BEGIN
1111: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') INTO L_ISSUE_AUTHORITY
1112: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
1113: WHERE T.CUSTOMER_TRX_ID = CUSTOMER_TRX_ID(I)
1114: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
1115:
1116: IF L_ISSUE_AUTHORITY = 'Y' THEN