[Home] [Help]
1008: l_count NUMBER;
1009: BEGIN
1010: select count(*)
1011: into l_count
1012: from xtr_party_info_v
1013: where party_type in ('CP','C')
1014: and ((party_type = 'CP' and mm_cparty='Y')
1015: or party_type = 'C')
1016: and party_code = p_cparty_code