APPS.CSP_TRANSACTIONS_PUB dependencies on DUAL

Line 804: FROM dual;

800: AND Inventory_item_id = p_inventory_item_id AND uom_code = p_uom;
801:
802: CURSOR l_transaction_header_id_csr IS
803: SELECT mtl_material_transactions_s.nextval
804: FROM dual;
805:
806:
807: CURSOR l_acct_period_csr is
808: SELECT acct_period_id,

Line 938: from dual;

934:
935: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
936: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
937: INTO p_org_id
938: from dual;
939:
940: SElECT gcc.code_combination_id
941: INTO l_code_comb_id
942: FROM hr_operating_units hou,gl_sets_of_books gsob,

Line 1642: FROM dual;

1638: where transaction_temp_id = l_transaction_temp_id;
1639:
1640: Cursor l_Get_txn_header_id_csr IS
1641: SELECT mtl_material_transactions_s.nextval
1642: FROM dual;
1643:
1644: Cursor l_Get_Mo_Header_id_csr(l_line_id NUMBER) IS
1645: select distinct header_id from csp_moveorder_lines
1646: where line_id = l_line_id;