DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 1379: FROM Wsh_Delivery_Assignments B,

1375: CURSOR Get_Status_Cur IS
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

Line 3687: FROM wsh_delivery_assignments

3683: AND tax_type='EXCISE_SH_EDU_CESS';
3684:
3685: CURSOR c_get_delivery_id IS
3686: SELECT To_Char(delivery_id)
3687: FROM wsh_delivery_assignments
3688: WHERE delivery_detail_id = pr_trig_row.delivery_detail_id;
3689:
3690: /*
3691: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books