APPS.PQH_GL_POSTING dependencies on DUAL

Line 1692: FROM dual;

1688: cost_allocation_keyflex_id,currency_code;
1689:
1690: CURSOR csr_packet_id IS
1691: SELECT gl_bc_packets_s.nextval
1692: FROM dual;
1693:
1694: CURSOR csr_period_name( p_period_name IN varchar2 ) IS
1695: SELECT *
1696: FROM gl_period_statuses

Line 5648: From dual;

5644: -- Select Batch Name for Transaction
5645: --
5646: Select
5647: 'PQH'||to_char(pqh_gms_batch_name_s.nextval) INTO p_gms_batch_name
5648: From dual;
5649:
5650: hr_utility.set_location('Batch Name: '||p_gms_batch_name, 15);
5651:
5652: FOR cnt in 1..g_gms_import_tab.COUNT LOOP

Line 5660: From dual;

5656: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
5657: --
5658: Select pa_txn_interface_s.nextval
5659: INTO l_txn_interface_id
5660: From dual;
5661: --
5662: -- Insert in to PA_TRANSACTIONS_ALL
5663: --
5664: INSERT INTO PA_TRANSACTION_INTERFACE_ALL

Line 5937: from dual;

5933: hr_utility.set_location('setting tab row '||cnt, 26);
5934:
5935: select pqh_gms_orig_txn_reference_s.nextval
5936: into ref_cnt
5937: from dual;
5938:
5939: g_gms_import_tab(cnt).EXPENDITURE_ENDING_DATE :=l_exp_end_dt;
5940: g_gms_import_tab(cnt).ORGANIZATION_NAME :=l_org_name;
5941: g_gms_import_tab(cnt).EXPENDITURE_ITEM_DATE :=l_effective_date;