APPS.JAI_EXCISE_SCRIPTS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 704: FROM JAI_CMN_INVENTORY_ORGS

700: SET balance = ln_prev_balance,
701: last_updated_by = p_last_updated_by,
702: last_update_date = sysdate
703: WHERE org_unit_id = ( SELECT org_unit_id
704: FROM JAI_CMN_INVENTORY_ORGS
705: WHERE organization_id = p_organization_id
706: AND location_id = p_location_id )
707: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C')
708: AND tax_type = p_tax_type;

Line 733: FROM JAI_CMN_INVENTORY_ORGS

729: SET balance = ln_prev_balance,
730: last_updated_by = p_last_updated_by,
731: last_update_date = sysdate
732: WHERE org_unit_id = ( SELECT org_unit_id
733: FROM JAI_CMN_INVENTORY_ORGS
734: WHERE organization_id = p_organization_id
735: AND location_id = p_location_id )
736: AND register_type = 'PLA'
737: AND tax_type = p_tax_type;

Line 797: FROM JAI_CMN_INVENTORY_ORGS

793:
794: UPDATE JAI_CMN_RG_OTH_BALANCES
795: SET balance = p_closing_balance
796: WHERE org_unit_id = ( SELECT org_unit_id
797: FROM JAI_CMN_INVENTORY_ORGS
798: WHERE organization_id = p_organization_id
799: AND location_id = p_location_id )
800: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C',p_register_type)
801: AND tax_type = p_tax_type

Line 978: FROM JAI_CMN_INVENTORY_ORGS

974: CURSOR cur_get_final_bal(cp_tax_type VARCHAR2) IS
975: SELECT balance
976: FROM JAI_CMN_RG_OTH_BALANCES
977: WHERE org_unit_id = ( SELECT org_unit_id
978: FROM JAI_CMN_INVENTORY_ORGS
979: WHERE organization_id = p_organization_id
980: AND location_id = p_location_id )
981: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C',p_register_type)
982: AND tax_type = cp_tax_type;

Line 2474: FROM JAI_CMN_INVENTORY_ORGS

2470: cp_tax_type VARCHAR2) IS
2471: SELECT balance
2472: FROM JAI_CMN_RG_OTH_BALANCES
2473: WHERE org_unit_id = ( SELECT org_unit_id
2474: FROM JAI_CMN_INVENTORY_ORGS
2475: WHERE organization_id = cp_organization_id
2476: AND location_id = cp_location_id )
2477: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C',p_register_type)
2478: AND tax_type = cp_tax_type;