DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1181: FROM JAI_CMN_RG_BALANCES

1177: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
1178:
1179: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1180: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance
1181: FROM JAI_CMN_RG_BALANCES
1182: WHERE organization_id = p_organization_id
1183: AND location_id = p_location_id ;
1184:
1185: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS