[Home] [Help]
479: Where qpt.plan_id=qpv.plan_id
480: and ml.lookup_code=qpt.mandatory_collection_flag
481: and ml.lookup_type='SYS_YES_NO'
482: and nvl(p_quality_flag,2)=decode(p_quality_flag,1,qpt.mandatory_collection_flag,2,p_quality_flag,2)
483: and decode(qpt.transaction_number,31,qa_web_txn_api.plan_applies(qpv.plan_id,qpt.transaction_number,to_char(p_organization_id),
484: p_asset_group,p_serial_number,p_asset_activity,p_wip_entity_name,'',p_instance_number,'','','','','EAM'),'N')='Y';
485:
486: --Cursor for Quality Plan Elements
487: cursor qplanelement_cursor(p_plan_id number) is