APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on WSH_NEW_DELIVERIES

Line 513: Wsh_New_deliveries A

509: SELECT A.delivery_id,
510: A.confirm_date,
511: A.status_code
512: FROM Wsh_Delivery_Assignments B,
513: Wsh_New_deliveries A
514: WHERE B.Delivery_Id = A.Delivery_Id
515: AND B.Delivery_Detail_id = v_delivery_detail_id;
516:
517: CURSOR get_item_attributes IS

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

2098: lv_source_name VARCHAR2(100) := 'Register India';
2099: lv_category_name VARCHAR2(100) := 'Register India';
2100: lv_reference_10 varchar2(100) := 'India Localization - RG23D Accounting Reversal on Shipment';
2101: lv_reference_23 varchar2(100) := 'jai_rg23d_shipment_acc_pkg.rg23d_rev_accounting';
2102: lv_reference_24 varchar2(100) := 'wsh_new_deliveries';
2103: lv_reference_26 varchar2(100) := To_Char(pr_trig_row.delivery_detail_id);
2104: lv_reference_25 varchar2(100) := 'delivery_id';
2105: lv_regime_code VARCHAR2(100) := 'EXCISE';
2106: lv_source_table VARCHAR2(100) := 'wsh_delivery_details';

Line 2708: Wsh_New_deliveries A

2704:
2705: CURSOR Get_Status_Cur IS
2706: SELECT A.status_code
2707: FROM Wsh_Delivery_Assignments B,
2708: Wsh_New_deliveries A
2709: WHERE B.Delivery_Id = A.Delivery_Id
2710: AND B.Delivery_Detail_id = v_delivery_detail_id;
2711:
2712: CURSOR Get_So_Lines_Count_Cur IS

Line 3044: Wsh_New_deliveries A

3040:
3041: CURSOR Get_Status_Cur IS
3042: SELECT A.confirm_date
3043: FROM Wsh_Delivery_Assignments B,
3044: Wsh_New_deliveries A
3045: WHERE B.Delivery_Id = A.Delivery_Id
3046: AND B.Delivery_Detail_id = v_delivery_detail_id;
3047:
3048: CURSOR C_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)