72: END LOOP;
73: FOR SLNO_REC IN (SELECT
74: MIN(REGISTER_ID) LO
75: FROM
76: JAI_CMN_RG_COMP_DTLS
77: WHERE ORGANIZATION_ID = nvl(P_ORGANIZATION_ID,207)
78: AND LOCATION_ID = nvl(P_LOCATION_ID,207)
79: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
80: ,TRUNC(TRANSACTION_DATE))
85: BASIC_OPENING_BALANCE BASICOB,
86: ADDITIONAL_OPENING_BALANCE ADLOB,
87: OTHER_OPENING_BALANCE OTHOB
88: FROM
89: JAI_CMN_RG_COMP_DTLS
90: WHERE REGISTER_ID = SLNO_REC.LO) LOOP
91: P_CENOB := NVL(VAL_REC.BASICOB
92: ,0);
93: P_ADLOB := NVL(VAL_REC.ADLOB
112: ,0) SEDCT,
113: NVL(SUM(CR_ADDITIONAL_ED)
114: ,0) ADLCT
115: FROM
116: JAI_CMN_RG_COMP_DTLS
117: WHERE ORGANIZATION_ID = nvl(P_ORGANIZATION_ID,207)
118: AND LOCATION_ID = nvl(P_LOCATION_ID,207)
119: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
120: ,TRUNC(TRANSACTION_DATE))
138: ,0) SEDCU,
139: NVL(SUM(DR_ADDITIONAL_ED)
140: ,0) ADLCU
141: FROM
142: JAI_CMN_RG_COMP_DTLS
143: WHERE ORGANIZATION_ID = nvl(P_ORGANIZATION_ID,207)
144: AND LOCATION_ID = nvl(P_LOCATION_ID,207)
145: AND TRUNC(TRANSACTION_DATE) BETWEEN NVL(TRUNC(P_TRN_FROM_DATE)
146: ,TRUNC(TRANSACTION_DATE))