APPS.JAI_CMN_RG_OTHERS_PKG dependencies on JAI_CMN_RG_OTH_BALANCES

Line 128: p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,

124:
125:
126: procedure check_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,
127: p_location_id HR_LOCATIONS.LOCATION_ID%TYPE ,
128: p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,
129: p_trx_amount NUMBER ,
130: p_process_flag OUT NOCOPY VARCHAR2 ,
131: p_process_message OUT NOCOPY VARCHAR2
132: )

Line 143: FROM JAI_CMN_RG_OTH_BALANCES

139: AND location_id = p_location_id ;
140:
141: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS
142: SELECT NVL(SUM(balance),0)
143: FROM JAI_CMN_RG_OTH_BALANCES
144: WHERE org_unit_id = cp_org_unit_id
145: and register_type = p_register_type
146: and tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess); --rchandan for bug#4428980
147:

Line 204: p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,

200: /*Procedure check_sh_balances is added to check balances for secondary and higher education cess */
201: -- start 5989740
202: procedure check_sh_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,
203: p_location_id HR_LOCATIONS.LOCATION_ID%TYPE ,
204: p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,
205: p_trx_amount NUMBER ,
206: p_process_flag OUT NOCOPY VARCHAR2 ,
207: p_process_message OUT NOCOPY VARCHAR2
208: )

Line 220: FROM JAI_CMN_RG_OTH_BALANCES

216:
217:
218: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS
219: SELECT NVL(SUM(balance),0)
220: FROM JAI_CMN_RG_OTH_BALANCES
221: WHERE org_unit_id = cp_org_unit_id
222: and register_type = p_register_type
223: and tax_type in ( jai_constants.tax_type_sh_exc_edu_cess,
224: jai_constants.tax_type_sh_cvd_edu_cess