APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on WSH_NEW_DELIVERIES

Line 1380: Wsh_New_deliveries A

1376: SELECT A.delivery_id,
1377: A.confirm_date,
1378: A.status_code
1379: FROM Wsh_Delivery_Assignments B,
1380: Wsh_New_deliveries A
1381: WHERE B.Delivery_Id = A.Delivery_Id
1382: AND B.Delivery_Detail_id = v_delivery_detail_id;
1383: --Added by GSRI for BUG 2283066
1384: /* Commented by Brathod for Bug# 4299606 (DFF Elimination)*/

Line 3734: lv_reference_24 varchar2(100) := 'wsh_new_deliveries';

3730: lv_source_name VARCHAR2(100) := 'Register India';
3731: lv_category_name VARCHAR2(100) := 'Register India';
3732: lv_reference_10 varchar2(100) := 'India Localization - RG23D Accounting Reversal on Shipment';
3733: lv_reference_23 varchar2(100) := 'jai_rg23d_shipment_acc_pkg.rg23d_rev_accounting';
3734: lv_reference_24 varchar2(100) := 'wsh_new_deliveries';
3735: lv_reference_26 varchar2(100) := To_Char(pr_trig_row.delivery_detail_id);
3736: lv_reference_25 varchar2(100) := 'delivery_id';
3737: lv_regime_code VARCHAR2(100) := 'EXCISE';
3738: lv_source_table VARCHAR2(100) := 'wsh_delivery_details';