APPS.CSP_TRANSACTIONS_PUB dependencies on DUAL

Line 692: FROM dual;

688: l_FINAL_COMPLETION_FLAG Varchar2(5);
689:
690: CURSOR l_transaction_header_id_csr IS
691: SELECT mtl_material_transactions_s.nextval
692: FROM dual;
693:
694:
695: CURSOR l_acct_period_csr is
696: SELECT acct_period_id

Line 813: from dual;

809:
810: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
811: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
812: INTO p_org_id
813: from dual;
814:
815: SElECT gcc.code_combination_id
816: INTO l_code_comb_id
817: FROM hr_operating_units hou,gl_sets_of_books gsob,

Line 1368: FROM dual;

1364: where transaction_temp_id = l_transaction_temp_id;
1365:
1366: Cursor l_Get_txn_header_id_csr IS
1367: SELECT mtl_material_transactions_s.nextval
1368: FROM dual;
1369:
1370: Cursor l_Get_Mo_Header_id_csr(l_line_id NUMBER) IS
1371: select distinct header_id from csp_moveorder_lines
1372: where line_id = l_line_id;