275: AND qp.organization_id <> 0
276: AND NOT EXISTS
277: (
278: SELECT 1
279: FROM qa_pc_plan_relationship
280: WHERE data_entry_mode = 4
281: AND child_plan_id = qp.plan_id
282: );
283:
635: AND low_value = p_old_value
636: AND plan_relationship_id IN
637: (
638: SELECT qppr.plan_relationship_id
639: FROM QA_PC_PLAN_RELATIONSHIP qppr,
640: QA_PLAN_CHARS qpc
641: WHERE qppr.parent_plan_id = qpc.plan_id
642: AND qpc.char_id = p_char_id
643: );
657: AND high_value = p_old_value
658: AND plan_relationship_id IN
659: (
660: SELECT qppr.plan_relationship_id
661: FROM QA_PC_PLAN_RELATIONSHIP qppr,
662: QA_PLAN_CHARS qpc
663: WHERE qppr.parent_plan_id = qpc.plan_id
664: AND qpc.char_id = p_char_id
665: );