APPS.JAI_PO_OSP_PKG dependencies on DUAL

Line 207: FROM dual;

203:
204: --******************FETCHING FORM ID FROM SEQUENCE************
205: CURSOR c_form_id IS
206: SELECT JAI_PO_OSP_HDRS_S.NEXTVAL
207: FROM dual;
208:
209: --******************FETCHING LINE ID FROM SEQUENCE************
210: CURSOR c_line_id IS
211: SELECT JAI_PO_OSP_LINES_S.NEXTVAL

Line 212: FROM dual;

208:
209: --******************FETCHING LINE ID FROM SEQUENCE************
210: CURSOR c_line_id IS
211: SELECT JAI_PO_OSP_LINES_S.NEXTVAL
212: FROM dual;
213: --*****************OSP RETURN DAYS****************************
214: CURSOR c_osp_days(cp_org_id NUMBER) IS
215: SELECT osp_return_days, osp_excise_percent
216: FROM JAI_CMN_INVENTORY_ORGS

Line 604: from dual

600: AND wip_supply_type <> 6
601: UNION
602: select c_po_dist.quantity_ordered , 1 , rec_po_line_cur.item_id , 1 ,
603: 'P' item_type, 'PO Entry' comments
604: from dual
605: where ( ln_routing_ctr > 0 OR ln_reqmt_op_ctr + ln_ja_ctr = 0) /*Bug 4609260*/
606: /*above condition changed for bug 8602495*/
607: union
608: select 1 , dtl.quantity , dtl.item_id , 1 , 'M' item_type,'Manual Entry' comments

Line 1577: 1 01-JUN-2001 Satya Added DUAL UOM functionality

1573: /*------------------------------------------------------------------------------------------
1574: CHANGE HISTORY: FILENAME: ja_in_update_57F4.sql
1575: S.No Date Author and Details
1576: ------------------------------------------------------------------------------------------
1577: 1 01-JUN-2001 Satya Added DUAL UOM functionality
1578:
1579: 2 29-OCT-2002 Nagaraj.s for Bug2643016
1580: As Functionally required, an Update statement is written to update the CR_REG_ENTRY_DATE of
1581: the ja_in_57f4_table. This will definitely have implications on Approve 57f4 receipt screen on