DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PA_TXN_INTERFACE_S

Line 5028: SELECT pa_txn_interface_s.NEXTVAL,

5024: End of Comment for Create and Update multi thread enh. *****/
5025:
5026: -- CURSOR int_cur(p_enc_control_id IN NUMBER) IS
5027: CURSOR int_cur IS
5028: SELECT pa_txn_interface_s.NEXTVAL,
5029: pesl.enc_summary_line_id,
5030: pesl.effective_date,
5031: pesl.time_period_id,
5032: pesl.person_id,

Line 5706: select pa_txn_interface_s.nextval

5702: ****************************************************************************************************** /
5703:
5704: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
5705:
5706: select pa_txn_interface_s.nextval
5707: into l_txn_interface_id
5708: from dual;
5709: ------Bug 2039196: Swapped the order of PA/GMS population
5710: -- dbms_output.put_line('Inserting into pa interface.............');