APPS.QA_PARENT_CHILD_PKG dependencies on QA_PLANS

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

252:
253: -- Bug 2448888. when all child plans have effective from and to date range is
254: -- outside the sysdate then, FRM-41084:- Error getting Group Cell raised when
255: -- child button is hit. This is similar to bug Bug 2355817.
256: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
257: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
258:
259: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
260: FROM qa_plans qp,

Line 260: FROM qa_plans qp,

256: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
257: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
258:
259: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
260: FROM qa_plans qp,
261: qa_pc_plan_relationship qpr
262: WHERE qpr.parent_plan_id = p_plan_id
263: AND qpr.child_plan_id = qp.plan_id
264: AND qpr.plan_relationship_type = 1

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

329:
330: -- Bug 2448888. when all child plans have effective from and to date range is
331: -- outside the sysdate then, FRM-41084:- Error getting Group Cell raised when
332: -- child button is hit. This is similar to bug Bug 2355817.
333: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
334: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
335:
336: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
337: FROM qa_plans qp,

Line 337: FROM qa_plans qp,

333: -- Make a join to qa_plans in cursor C and fetch only effective child plans.
334: -- rponnusa Tue Jul 9 00:25:19 PDT 2002
335:
336: CURSOR c IS SELECT qpr.plan_relationship_id,qpr.child_plan_id
337: FROM qa_plans qp,
338: qa_pc_plan_relationship qpr
339: WHERE qpr.parent_plan_id = p_plan_id
340: AND qpr.child_plan_id = qp.plan_id
341: AND qpr.plan_relationship_type = 1

Line 499: FROM qa_plans

495: -- data range. Bug 2355817. kabalakr 06 MAY 2002.
496:
497: CURSOR p(l_child_plan_id NUMBER) IS
498: SELECT plan_id
499: FROM qa_plans
500: WHERE plan_id = l_child_plan_id
501: AND ((effective_to IS NULL AND TRUNC(SYSDATE) >= effective_from)
502: OR (effective_from IS NULL AND TRUNC(SYSDATE) <= effective_to)
503: OR (effective_from IS NOT NULL AND effective_to IS NOT NULL

Line 667: qa_plans qp

663: SELECT
664: qpc.char_id,
665: qpc.default_value
666: FROM qa_plan_chars qpc,
667: qa_plans qp
668: WHERE qp.plan_id = qpc.plan_id
669: AND qpc.default_value IS NOT NULL
670: AND qpc.enabled_flag=1
671: AND qp.plan_id = c_child_plan_id;

Line 1600: FROM qa_plans

1596: l_separator CONSTANT VARCHAR2(1) := ',';
1597:
1598: CURSOR plan_cursor(c_plan_id NUMBER) IS
1599: SELECT name
1600: FROM qa_plans
1601: WHERE plan_id = c_plan_id;
1602:
1603: BEGIN
1604: l_total_length := LENGTH(p_plan_ids);

Line 2547: FROM qa_plans

2543: --IF NOT parent_plan_vales_tab.exists(p_parent_plan_id ||'*'||p_parent_collection_id||'*'||p_parent_occurrence||'*'||p_child_plan_id) THEN
2544: IF (NOT parent_plan_vales_tab.exists(p_parent_plan_id ||'*'||p_parent_collection_id||'*'||p_parent_occurrence||'*'||p_child_plan_id) OR
2545: l_seq_flag = TRUE) THEN
2546: SELECT deref_view_name INTO l_plan_view_name
2547: FROM qa_plans
2548: WHERE plan_id = p_parent_plan_id;
2549:
2550: --
2551: -- Bug 7588376

Line 3422: FROM qa_plans qp,

3418: CURSOR c IS
3419: SELECT qpr.plan_relationship_id,
3420: qpr.child_plan_id,
3421: qpr.data_entry_mode
3422: FROM qa_plans qp,
3423: qa_pc_plan_relationship qpr
3424: WHERE qpr.parent_plan_id = p_plan_id
3425: AND qpr.child_plan_id = qp.plan_id
3426: AND qpr.plan_relationship_type = 1