APPS.QA_PARENT_CHILD_PKG dependencies on QA_PC_RESULT_COLUMNS_V

Line 693: FROM qa_pc_result_columns_v

689: -- are copied.
690:
691: CURSOR char_id_cur(c_child_plan_id NUMBER) IS
692: SELECT parent_char_id, child_char_id
693: FROM qa_pc_result_columns_v
694: WHERE parent_plan_id = p_plan_id
695: AND child_plan_id = c_child_plan_id
696: AND parent_enabled_flag = 1
697: AND child_enabled_flag = 1;

Line 716: FROM qa_pc_result_columns_v

712: AND qpc.enabled_flag = 1
713: AND qc.datatype = 5
714: MINUS
715: SELECT child_char_id
716: FROM qa_pc_result_columns_v
717: WHERE parent_plan_id = p_plan_id
718: AND child_plan_id = c_child_plan_id
719: AND parent_enabled_flag = 1
720: AND child_enabled_flag = 1;

Line 731: FROM qa_pc_result_columns_v

727: AND qpc.enabled_flag = 1
728: AND qc.datatype = 5
729: AND qc.char_id NOT IN
730: (SELECT child_char_id
731: FROM qa_pc_result_columns_v
732: WHERE parent_plan_id = p_plan_id
733: AND child_plan_id = c_child_plan_id
734: AND parent_enabled_flag = 1
735: AND child_enabled_flag = 1);

Line 1781: FROM qa_pc_result_columns_v

1777: SELECT parent_database_column,
1778: child_database_column,
1779: element_relationship_type,
1780: parent_char_id
1781: FROM qa_pc_result_columns_v
1782: WHERE parent_plan_id = p_parent_plan_id
1783: AND child_plan_id = p_child_plan_id
1784: AND element_relationship_type in (2,3,4,5,6,7,8)
1785: AND parent_enabled_flag = 1

Line 2648: -- qa_pc_result_columns_v. I added link_flag in where clause.

2644: p_child_occurrence IN NUMBER)
2645: RETURN VARCHAR2 IS
2646:
2647: -- the following cursor contains sql text used for the view
2648: -- qa_pc_result_columns_v. I added link_flag in where clause.
2649:
2650: -- anagarwa Mon Dec 16 16:55:09 PST 2002
2651: -- Bug 2701777
2652: -- added parent_enabled_flag and child_enabled_flag to where clause

Line 2659: qa_pc_result_columns_v qprc

2655: CURSOR element_cursor IS
2656: SELECT qprc.parent_database_column,
2657: qprc.child_database_column
2658: FROM
2659: qa_pc_result_columns_v qprc
2660: WHERE
2661: qprc.parent_plan_id = p_parent_plan_id and
2662: qprc.child_plan_id = p_child_plan_id and
2663: qprc.element_relationship_type = 1 and

Line 2776: qa_pc_result_columns_v qprc

2772: Cursor element_cur(p_parentdbcol VARCHAR2) IS
2773: SELECT qprc.parent_database_column parent_database_column,
2774: qprc.child_database_column child_database_column
2775: FROM
2776: qa_pc_result_columns_v qprc
2777: WHERE
2778: qprc.parent_plan_id = p_parent_plan_id and
2779: qprc.child_plan_id = p_child_plan_id and
2780: qprc.element_relationship_type = 1 and

Line 2793: qa_pc_result_columns_v qprc

2789: SELECT qprc.parent_database_column parent_database_column,
2790: qprc.child_database_column child_database_column
2791: BULK COLLECT INTO p_elements_tab
2792: FROM
2793: qa_pc_result_columns_v qprc
2794: WHERE
2795: qprc.parent_plan_id = p_parent_plan_id and
2796: qprc.child_plan_id = p_child_plan_id and
2797: qprc.element_relationship_type = 1 and

Line 3482: FROM qa_pc_result_columns_v

3478: p_txn_or_child_flag IN NUMBER)
3479: RETURN VARCHAR2 IS
3480:
3481: CURSOR c IS SELECT 1
3482: FROM qa_pc_result_columns_v
3483: WHERE child_plan_id = p_plan_id and
3484: child_char_id = p_char_id and
3485: parent_plan_id = p_parent_plan_id and
3486: ELEMENT_RELATIONSHIP_TYPE = 1;

Line 3516: FROM qa_pc_result_columns_v

3512: p_plan_id IN NUMBER)
3513: RETURN VARCHAR2 IS
3514:
3515: CURSOR c IS SELECT parent_char_id
3516: FROM qa_pc_result_columns_v
3517: WHERE parent_plan_id = p_plan_id and
3518: child_char_id = p_child_char_id and
3519: element_relationship_type = 1;
3520:

Line 3550: FROM qa_pc_result_columns_v

3546: p_child_plan_id IN NUMBER)
3547: RETURN VARCHAR2 IS
3548:
3549: CURSOR c IS SELECT parent_char_id
3550: FROM qa_pc_result_columns_v
3551: WHERE parent_plan_id = p_plan_id and
3552: child_plan_id = p_child_plan_id and
3553: child_char_id = p_child_char_id and
3554: element_relationship_type = 1;

Line 3745: FROM qa_pc_result_columns_v

3741: SELECT parent_database_column,
3742: child_database_column,
3743: element_relationship_type,
3744: parent_char_id
3745: FROM qa_pc_result_columns_v
3746: WHERE parent_plan_id = p_parent_plan_id
3747: AND child_plan_id = p_child_plan_id
3748: AND element_relationship_type in (2,3,4,5,6,7,8)
3749: AND parent_enabled_flag = 1

Line 4219: FROM qa_pc_result_columns_v qprc

4215:
4216: CURSOR C IS
4217: SELECT qprc.parent_database_column,
4218: qprc.child_database_column
4219: FROM qa_pc_result_columns_v qprc
4220: WHERE qprc.parent_plan_id = p_parent_plan_id and
4221: qprc.child_plan_id = p_child_plan_id and
4222: qprc.element_relationship_type = 1 and
4223: parent_enabled_flag = 1 and

Line 4940: FROM qa_pc_result_columns_v

4936: p_child_plan_id IN NUMBER)
4937: RETURN VARCHAR2 IS
4938:
4939: CURSOR c IS SELECT parent_database_column
4940: FROM qa_pc_result_columns_v
4941: WHERE parent_plan_id = p_plan_id and
4942: child_plan_id = p_child_plan_id and
4943: child_char_id = p_child_char_id and
4944: element_relationship_type = 1;