APPS.PQH_COMMITMENT_POSTING dependencies on DUAL

Line 2725: FROM dual;

2721: cost_allocation_keyflex_id,currency_code;
2722: --
2723: CURSOR csr_packet_id IS
2724: SELECT gl_bc_packets_s.nextval
2725: FROM dual;
2726: --
2727: CURSOR csr_period_name( p_period_name IN varchar2 ) IS
2728: SELECT *
2729: FROM gl_period_statuses

Line 4508: From dual;

4504: -- Select Batch Name for Transaction
4505: --
4506: Select
4507: 'PQH'||to_char(pqh_gms_batch_name_s.nextval) INTO p_gms_batch_name
4508: From dual;
4509:
4510: hr_utility.set_location('Batch Name: '||p_gms_batch_name, 15);
4511:
4512: FOR cnt in 1..g_gms_import_tab.COUNT LOOP

Line 4520: From dual;

4516: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
4517: --
4518: Select pa_txn_interface_s.nextval
4519: INTO l_txn_interface_id
4520: From dual;
4521: --
4522: -- Insert in to PA_TRANSACTIONS_ALL
4523: --
4524: INSERT INTO PA_TRANSACTION_INTERFACE_ALL

Line 4970: from dual;

4966: hr_utility.set_location('setting tab row '||cnt, 26);
4967:
4968: select pqh_gms_orig_txn_reference_s.nextval
4969: into ref_cnt
4970: from dual;
4971:
4972: g_gms_import_tab(cnt).EXPENDITURE_ENDING_DATE :=l_exp_end_dt;
4973: g_gms_import_tab(cnt).ORGANIZATION_NAME :=l_org_name;
4974: g_gms_import_tab(cnt).EXPENDITURE_ITEM_DATE :=l_effective_date;