DBA Data[Home] [Help]

APPS.PQH_TEM_BUS dependencies on PQH_POSITION_TRANSACTIONS

Line 1422: From pqh_position_transactions ptx

1418: Select null
1419: from pqh_transaction_templates tt
1420: Where tt.template_id = p_template_id
1421: AND tt.transaction_id in (Select ptx.position_transaction_id
1422: From pqh_position_transactions ptx
1423: Where nvl(ptx.transaction_status,'PENDING') in
1424: ('APPROVED','SUBMITTED','PENDING'));
1425: --
1426: l_dummy varchar2(1);