DBA Data[Home] [Help]

APPS.JA_JAINABST_EXC_XMLP_PKG dependencies on JAI_CMN_RG_COMP_DTLS

Line 76: JAI_CMN_RG_COMP_DTLS

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))

Line 89: JAI_CMN_RG_COMP_DTLS

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

Line 116: JAI_CMN_RG_COMP_DTLS

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))

Line 142: JAI_CMN_RG_COMP_DTLS

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))