APPS.AHL_PRD_WO_PUB dependencies on QA_PLAN_CHARS_V

Line 1107: FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;

1103: , DECODE( NVL( sql_string_flag, 'N' ), 'N', DECODE( hardcoded_column, NULL, 'N', DECODE( QA_SS_LOV_API.get_lov_sql( plan_id, char_id, organization_id, null, null, null, null, null ), NULL, 'N', 'Y' ) ), sql_string_flag ) sql_string_flag
1104: , values_exist_flag, displayed_flag
1105: , char_name , datatype , display_length, hardcoded_column
1106: , developer_name , mandatory_flag
1107: FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;
1108:
1109: CURSOR get_plan_csr(p_plan_id IN NUMBER) IS
1110: SELECT plan_id , organization_id, name
1111: , description FROM QA_PLANS_V

Line 1436: FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;

1432: , DECODE( NVL( sql_string_flag, 'N' ), 'N', DECODE( hardcoded_column, NULL, 'N', DECODE( QA_SS_LOV_API.get_lov_sql( plan_id, char_id, organization_id, null, null, null, null, null ), NULL, 'N', 'Y' ) ), sql_string_flag ) sql_string_flag
1433: , values_exist_flag, displayed_flag
1434: , char_name , datatype , display_length, hardcoded_column
1435: , developer_name , mandatory_flag
1436: FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;
1437:
1438: l_sql_string VARCHAR2(6000);
1439: l_result_column VARCHAR2(240);
1440: l_result_column_name VARCHAR2(240);