APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 395: from JAI_CMN_INVENTORY_ORGS

391:
392: -- added by sriram - bug#3441684
393: cursor c_orgn_info is
394: select trading
395: from JAI_CMN_INVENTORY_ORGS
396: where organization_id = pr_new.organization_id
397: and location_id = pr_new.ship_from_location_id ;
398: --ends here additions by sriram - bug#3441684
399:

Line 1122: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;

1118: v_exe_flag VARCHAR2(150);
1119: v_mod_flag VARCHAR2(150);
1120: --New Variables Declared by Nagaraj.s for Enh2415656
1121: v_output NUMBER ;-- By Nagaraj.s to get the output of the function jai_om_wsh_processing_pkg.excise_balance_check
1122: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
1123: v_basic_pla_balance NUMBER;
1124: v_additional_pla_balance NUMBER;
1125: v_other_pla_balance NUMBER;
1126: v_error_message NUMBER; --This is for Capturing the Error Message

Line 1400: FROM JAI_CMN_INVENTORY_ORGS

1396: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1397: --This is included in the select by Nagaraj.s for Enh2415656
1398: SELECT pref_rg23a, pref_rg23c, pref_pla,
1399: NVL(Export_oriented_unit ,'N')
1400: FROM JAI_CMN_INVENTORY_ORGS
1401: WHERE organization_id = p_organization_id
1402: AND location_id = p_location_id ;
1403: --This is included in the select by Nagaraj.s for Enh2415656
1404: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS

Line 1414: FROM JAI_CMN_INVENTORY_ORGS

1410: WHERE organization_id = p_organization_id
1411: AND location_id = p_location_id ;
1412: CURSOR ssi_unit_flag_cur(p_organization_id NUMBER, p_location_id NUMBER) IS
1413: SELECT ssi_unit_flag
1414: FROM JAI_CMN_INVENTORY_ORGS
1415: WHERE organization_id = p_organization_id
1416: AND location_id = p_location_id;
1417: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1418: SELECT register_balance

Line 1434: FROM JAI_CMN_INVENTORY_ORGS

1430: AND b.tax_type = 'Modvat Recovery'
1431: ORDER BY A.Tax_Line_No;
1432: CURSOR for_modvat_percentage(p_organization_id NUMBER, p_location_id NUMBER) IS
1433: SELECT MODVAT_REVERSE_PERCENT
1434: FROM JAI_CMN_INVENTORY_ORGS
1435: WHERE organization_id = p_organization_id
1436: AND ( location_id = p_location_id
1437: OR
1438: location_id is NULL AND p_location_id is NULL); /* Modified by Ramananda for removal of SQL LITERALs */