1089: wdd.delivery_detail_id,
1090: wnd.confirm_date
1091: FROM
1092: wsh_delivery_details wdd,
1093: wsh_delivery_assignments wda,
1094: wsh_new_deliveries wnd
1095: WHERE
1096: wdd.delivery_detail_id = p_ddetail_id AND -- Added p_ddetail_id by bgowrava for bug#6126581
1097: wda.delivery_detail_id = wdd.delivery_detail_id AND
3514: select
3515: confirm_date
3516: FROM
3517: wsh_delivery_details wdd,
3518: wsh_delivery_assignments wda,
3519: wsh_new_deliveries wnd
3520: WHERE
3521: wdd.delivery_detail_id = (p_delivery_Detail_id)
3522: AND