DBA Data[Home] [Help]

APPS.QA_CHAR_UPDATE_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 279: FROM qa_pc_plan_relationship

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:

Line 639: FROM QA_PC_PLAN_RELATIONSHIP qppr,

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: );

Line 661: FROM QA_PC_PLAN_RELATIONSHIP qppr,

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: );