APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 269: FROM qa_pc_plan_relationship

265: -- local variables will be used instead of input variables.
266: CURSOR c(c_parent_plan_id NUMBER,
267: c_child_plan_id NUMBER) IS
268: SELECT 1
269: FROM qa_pc_plan_relationship
270: WHERE parent_plan_id = c_parent_plan_id
271: AND child_plan_id = c_child_plan_id;
272:
273: BEGIN

Line 378: FROM qa_pc_plan_relationship

374: -- local variables will be used instead of inout variables.
375: CURSOR c(c_parent_plan_id NUMBER,
376: c_child_plan_id NUMBER) IS
377: SELECT 1
378: FROM qa_pc_plan_relationship
379: WHERE parent_plan_id = c_parent_plan_id
380: AND child_plan_id = c_child_plan_id;
381:
382: BEGIN

Line 717: from qa_pc_plan_relationship

713:
714: CURSOR c IS
715:
716: select rowid
717: from qa_pc_plan_relationship
718: where plan_relationship_id = p_plan_relationship_id;
719:
720: BEGIN
721:

Line 864: FROM qa_pc_plan_relationship

860: RETURN VARCHAR2 IS
861:
862: CURSOR c(c_child_plan_id NUMBER) IS
863: SELECT 1
864: FROM qa_pc_plan_relationship
865: WHERE parent_plan_id = c_child_plan_id;
866:
867: l_exists NUMBER:= -1;
868:

Line 1020: DELETE FROM QA_PC_PLAN_RELATIONSHIP

1016: PROCEDURE delete_plan_rel(p_plan_relationship_id NUMBER) IS
1017:
1018: BEGIN
1019:
1020: DELETE FROM QA_PC_PLAN_RELATIONSHIP
1021: WHERE plan_relationship_id = p_plan_relationship_id;
1022:
1023: DELETE FROM QA_PC_ELEMENT_RELATIONSHIP
1024: WHERE plan_relationship_id = p_plan_relationship_id;

Line 1052: from qa_pc_plan_relationship qpr, qa_plans qp

1048: l_search_array qa_txn_grp.ElementsArray;
1049:
1050: cursor l_plans_cursor IS
1051: select distinct qpr.parent_plan_id
1052: from qa_pc_plan_relationship qpr, qa_plans qp
1053: where qpr.parent_plan_id = qp.plan_id
1054: and qp.organization_id = p_org_id;
1055: BEGIN
1056: --sanity check, don't let them blink search using an org