APPS.AHL_PRD_PRINT_PVT dependencies on QA_PLAN_CHARS

Line 1118: QA_PLAN_CHARS_V QA

1114: datatype,
1115: hardcoded_column,
1116: developer_name
1117: FROM
1118: QA_PLAN_CHARS_V QA
1119: WHERE
1120: plan_id = p_plan_id;
1121:
1122: --local variable to hold the query string to retrieve qa results

Line 2408: FROM QA_PLAN_CHARS_V

2404: CURSOR qa_plan_csr(c_qa_plan_id IN NUMBER)
2405: IS
2406: SELECT DISTINCT plan_name,
2407: plan_description
2408: FROM QA_PLAN_CHARS_V
2409: WHERE plan_id = c_qa_plan_id;
2410:
2411: CURSOR get_op_qa_res_csr(c_wo_op_id IN NUMBER)
2412: IS

Line 2451: FROM QA_PLAN_CHARS

2447: prompt Prompt ,
2448: default_value DefaultValue ,
2449: enabled_flag ,
2450: displayed_flag
2451: FROM QA_PLAN_CHARS
2452: WHERE plan_id = c_plan_id
2453: ORDER BY 2;
2454:
2455: CURSOR route_ffs_csr(c_route_id IN NUMBER)

Line 2842: FROM QA_PLAN_CHARS

2838: SELECT char_id "CharId" ,
2839: prompt_sequence "PromptSequence",
2840: prompt "Prompt" ,
2841: default_value "DefaultValue"
2842: FROM QA_PLAN_CHARS
2843: WHERE plan_id = :1';
2844:
2845: l_qa_res_details VARCHAR2(1000) := '
2846: SELECT QC.char_id "CharId",

Line 2849: QA_PLAN_CHARS QC ,

2845: l_qa_res_details VARCHAR2(1000) := '
2846: SELECT QC.char_id "CharId",
2847: CI.attribute_value "AttributeValue"
2848: FROM CSI_IEA_VALUES CI,
2849: QA_PLAN_CHARS QC ,
2850: QA_RESULTS_V QR
2851: WHERE QC.plan_id = QR.plan_id
2852: AND CI.instance_id(+) = QR.csi_instance_id
2853: AND QR.collection_id = :1';

Line 7527: QA_PLAN_CHARS_V QA

7523: datatype,
7524: hardcoded_column,
7525: developer_name
7526: FROM
7527: QA_PLAN_CHARS_V QA
7528: WHERE
7529: plan_id = p_plan_id
7530: AND enabled_flag = 1
7531: AND displayed_flag = 1

Line 8095: FROM QA_PLAN_CHARS_V

8091: CURSOR qa_plan_csr(c_qa_plan_id IN NUMBER)
8092: IS
8093: SELECT DISTINCT plan_name,
8094: plan_description
8095: FROM QA_PLAN_CHARS_V
8096: WHERE plan_id = c_qa_plan_id;
8097:
8098: CURSOR get_op_qa_res_csr(c_wo_op_id IN NUMBER)
8099: IS

Line 8138: FROM QA_PLAN_CHARS

8134: prompt Prompt ,
8135: default_value DefaultValue ,
8136: enabled_flag ,
8137: displayed_flag
8138: FROM QA_PLAN_CHARS
8139: WHERE plan_id = c_plan_id
8140: ORDER BY 2;
8141:
8142: CURSOR route_ffs_csr(c_route_id IN NUMBER)

Line 8311: FROM QA_PLAN_CHARS

8307: SELECT char_id "CharId" ,
8308: prompt_sequence "PromptSequence",
8309: prompt "Prompt" ,
8310: default_value "DefaultValue"
8311: FROM QA_PLAN_CHARS
8312: WHERE plan_id = :1';
8313:
8314: l_qa_res_details VARCHAR2(1000) := '
8315: SELECT QC.char_id "CharId",

Line 8318: QA_PLAN_CHARS QC ,

8314: l_qa_res_details VARCHAR2(1000) := '
8315: SELECT QC.char_id "CharId",
8316: CI.attribute_value "AttributeValue"
8317: FROM CSI_IEA_VALUES CI,
8318: QA_PLAN_CHARS QC ,
8319: QA_RESULTS_V QR
8320: WHERE QC.plan_id = QR.plan_id
8321: AND CI.instance_id(+) = QR.csi_instance_id
8322: AND QR.collection_id = :1';