APPS.QA_PARENT_CHILD_PKG dependencies on QA_PLANS

Line 247: -- Make a join to qa_plans in cursor C and fetch only effective child plans.

243:
244: -- Bug 2448888. when all child plans have effective from and to date range is
245: -- outside the sysdate then, FRM-41084:- Error getting Group Cell raised when
246: -- child button is hit. This is similar to bug Bug 2355817.
247: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
248: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
249:
250: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
251: FROM qa_plans qp,

Line 251: FROM qa_plans qp,

247: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
248: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
249:
250: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
251: FROM qa_plans qp,
252: qa_pc_plan_relationship qpr
253: WHERE qpr.parent_plan_id = p_plan_id
254: AND qpr.child_plan_id = qp.plan_id
255: AND qpr.plan_relationship_type = 1

Line 324: -- Make a join to qa_plans in cursor C and fetch only effective child plans.

320:
321: -- Bug 2448888. when all child plans have effective from and to date range is
322: -- outside the sysdate then, FRM-41084:- Error getting Group Cell raised when
323: -- child button is hit. This is similar to bug Bug 2355817.
324: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
325: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
326:
327: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
328: FROM qa_plans qp,

Line 328: FROM qa_plans qp,

324: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
325: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
326:
327: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
328: FROM qa_plans qp,
329: qa_pc_plan_relationship qpr
330: WHERE qpr.parent_plan_id = p_plan_id
331: AND qpr.child_plan_id = qp.plan_id
332: AND qpr.plan_relationship_type = 1

Line 490: FROM qa_plans

486: -- data range. Bug 2355817. kabalakr 06 MAY 2002.
487:
488: CURSOR p(l_child_plan_id NUMBER) IS
489: SELECT plan_id
490: FROM qa_plans
491: WHERE plan_id = l_child_plan_id
492: AND ((effective_to IS NULL AND TRUNC(SYSDATE) >= effective_from)
493: OR (effective_from IS NULL AND TRUNC(SYSDATE) <= effective_to)
494: OR (effective_from IS NOT NULL AND effective_to IS NOT NULL

Line 1515: FROM qa_plans

1511: l_separator CONSTANT VARCHAR2(1) := ',';
1512:
1513: CURSOR plan_cursor(c_plan_id NUMBER) IS
1514: SELECT name
1515: FROM qa_plans
1516: WHERE plan_id = c_plan_id;
1517:
1518: BEGIN
1519: l_total_length := LENGTH(p_plan_ids);

Line 3094: FROM qa_plans qp,

3090: CURSOR c IS
3091: SELECT qpr.plan_relationship_id,
3092: qpr.child_plan_id,
3093: qpr.data_entry_mode
3094: FROM qa_plans qp,
3095: qa_pc_plan_relationship qpr
3096: WHERE qpr.parent_plan_id = p_plan_id
3097: AND qpr.child_plan_id = qp.plan_id
3098: AND qpr.plan_relationship_type = 1