APPS.JA_JAINEXCLIABILITY_XMLP_PKG dependencies on JAI_CMN_RG_COMP_DTLS

Line 74: JAI_CMN_RG_COMP_DTLS

70: END LOOP;
71: FOR SLNO_REC IN (SELECT
72: MIN(REGISTER_ID) LO
73: FROM
74: JAI_CMN_RG_COMP_DTLS
75: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
76: AND LOCATION_ID = P_LOCATION_ID
77: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
78: ,TRUNC(TRANSACTION_DATE))

Line 87: JAI_CMN_RG_COMP_DTLS

83: BASIC_OPENING_BALANCE BASICOB,
84: ADDITIONAL_OPENING_BALANCE ADLOB,
85: OTHER_OPENING_BALANCE OTHOB
86: FROM
87: JAI_CMN_RG_COMP_DTLS
88: WHERE REGISTER_ID = SLNO_REC.LO) LOOP
89: P_CENOBRG23A := NVL(VAL_REC.BASICOB
90: ,0);
91: P_ADLOBRG23A := NVL(VAL_REC.ADLOB

Line 114: JAI_CMN_RG_COMP_DTLS

110: ,0) SEDCT,
111: NVL(SUM(CR_ADDITIONAL_ED)
112: ,0) ADLCT
113: FROM
114: JAI_CMN_RG_COMP_DTLS
115: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
116: AND LOCATION_ID = P_LOCATION_ID
117: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
118: ,TRUNC(TRANSACTION_DATE))

Line 140: JAI_CMN_RG_COMP_DTLS

136: ,0) SEDCU,
137: NVL(SUM(DR_ADDITIONAL_ED)
138: ,0) ADLCU
139: FROM
140: JAI_CMN_RG_COMP_DTLS
141: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
142: AND LOCATION_ID = P_LOCATION_ID
143: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
144: ,TRUNC(TRANSACTION_DATE))

Line 173: JAI_CMN_RG_COMP_DTLS

169: ,0);
170: FOR SLNO_REC IN (SELECT
171: MIN(REGISTER_ID) LO
172: FROM
173: JAI_CMN_RG_COMP_DTLS
174: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
175: AND LOCATION_ID = P_LOCATION_ID
176: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
177: ,TRUNC(TRANSACTION_DATE))

Line 186: JAI_CMN_RG_COMP_DTLS

182: BASIC_OPENING_BALANCE BASICOB,
183: ADDITIONAL_OPENING_BALANCE ADLOB,
184: OTHER_OPENING_BALANCE OTHOB
185: FROM
186: JAI_CMN_RG_COMP_DTLS
187: WHERE REGISTER_ID = SLNO_REC.LO) LOOP
188: P_CENOBRG23C := NVL(VAL_REC.BASICOB
189: ,0);
190: P_ADLOBRG23C := NVL(VAL_REC.ADLOB

Line 213: JAI_CMN_RG_COMP_DTLS

209: ,0) SEDCT,
210: NVL(SUM(CR_ADDITIONAL_ED)
211: ,0) ADLCT
212: FROM
213: JAI_CMN_RG_COMP_DTLS
214: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
215: AND LOCATION_ID = P_LOCATION_ID
216: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
217: ,TRUNC(TRANSACTION_DATE))

Line 239: JAI_CMN_RG_COMP_DTLS

235: ,0) SEDCU,
236: NVL(SUM(DR_ADDITIONAL_ED)
237: ,0) ADLCU
238: FROM
239: JAI_CMN_RG_COMP_DTLS
240: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
241: AND LOCATION_ID = P_LOCATION_ID
242: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
243: ,TRUNC(TRANSACTION_DATE))