APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 512: FROM Wsh_Delivery_Assignments B,

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

Line 2058: FROM wsh_delivery_assignments

2054: AND tax_type = 'EXCISE_SH_EDU_CESS';
2055:
2056: CURSOR c_get_delivery_id IS
2057: SELECT To_Char(delivery_id)
2058: FROM wsh_delivery_assignments
2059: WHERE delivery_detail_id = pr_trig_row.delivery_detail_id;
2060:
2061: /*
2062: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books

Line 2707: FROM Wsh_Delivery_Assignments B,

2703: v_status_code VARCHAR2(2);
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:

Line 3043: FROM Wsh_Delivery_Assignments B,

3039: AND JSPT.DELIVERY_DETAIL_ID = CP_DELIVERY_DETAIL_ID;
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:

Line 3447: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)

3443: le_val Exception;
3444: lt_exp_msg exp_tbl_type := exp_tbl_type();
3445: rec_exp_msg JAI_WSH_EXCEPTIONS_T%ROWTYPE;
3446:
3447: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
3448: is
3449: SELECT *
3450: FROM wsh_delivery_details
3451: WHERE delivery_detail_id IN

Line 3455: wsh_delivery_assignments

3451: WHERE delivery_detail_id IN
3452: ( SELECT
3453: delivery_detail_id
3454: FROM
3455: wsh_delivery_assignments
3456: WHERE
3457: delivery_id = p_delivery_id
3458: );
3459: BEGIN

Line 3591: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)

3587: lv_return_msg VARCHAR2(240);
3588:
3589: le_sub Exception;
3590:
3591: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
3592: is
3593: SELECT *
3594: FROM wsh_delivery_details
3595: WHERE delivery_detail_id IN

Line 3599: wsh_delivery_assignments

3595: WHERE delivery_detail_id IN
3596: ( SELECT
3597: delivery_detail_id
3598: FROM
3599: wsh_delivery_assignments
3600: WHERE
3601: delivery_id = p_delivery_id
3602: );
3603: BEGIN

Line 3806: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)

3802: lv_location_id number;
3803: ln_req_id number;
3804: lv_delivery_id number;
3805:
3806: cursor c_get_delivery_details(p_delivery_id wsh_delivery_assignments.delivery_id%type)
3807: is
3808: SELECT *
3809: FROM wsh_delivery_details
3810: WHERE delivery_detail_id IN

Line 3814: wsh_delivery_assignments

3810: WHERE delivery_detail_id IN
3811: ( SELECT
3812: delivery_detail_id
3813: FROM
3814: wsh_delivery_assignments
3815: WHERE
3816: delivery_id = p_delivery_id
3817: );
3818: