873: p_txn_subtype VARCHAR2
874: )IS
875: SELECT tp_detail_id
876: FROM
877: ecx_tp_details tpd,
878: ecx_tp_headers tph,
879: ecx_ext_processes extp,
880: ecx_transactions txn,
881: ecx_standards svl
997: BEGIN
998: SELECT count(*)
999: INTO l_count
1000: FROM ecx_ext_processes extp,
1001: ecx_tp_details tpd,
1002: ecx_standards svl
1003: WHERE 1=1
1004: AND extp.standard_id = svl.standard_id
1005: AND svl.standard_code = p_std_code