586: l_dummy varchar2(1);
587: --
588: Cursor csr_tem_appl is
589: Select null
590: from pqh_transaction_templates
591: Where template_id = p_template_id;
592: --
593: Begin
594: --
1415: --
1416: --
1417: Cursor c1(p_template_id in number) is
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