DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_COPY_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 21: FROM qa_pc_plan_relationship qpr

17: CURSOR C1 (parent_id NUMBER, child_id NUMBER) IS
18: SELECT qpr.plan_relationship_id, qpr.data_entry_mode, qpr.auto_row_count,
19: qpr.plan_relationship_type,
20: qpr.default_parent_spec, qpr.layout_mode
21: FROM qa_pc_plan_relationship qpr
22: WHERE qpr.parent_plan_id = parent_id
23: AND qpr.child_plan_id = child_id
24: ORDER BY qpr.creation_date DESC;
25: c1_rec C1%ROWTYPE;

Line 818: FROM qa_pc_plan_relationship

814: user_name fnd_user.user_name%TYPE := get_user_name(fnd_global.user_id);
815: --user_name fnd_user.user_name%TYPE := 'MFG';
816: CURSOR C1(parent_id NUMBER) IS
817: SELECT child_plan_id
818: FROM qa_pc_plan_relationship
819: WHERE parent_plan_id = parent_id;
820:
821: -- Bug 3926150. Performance: searching on softcoded element improved by functional indexes.
822: -- Added the cursor qa_pc, which returns char details of enabled functional indexes.