APPS.AHL_PRD_WO_PUB dependencies on QA_SS_LOV_API

Line 1082: , 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

1078: CURSOR get_plan_attributes_csr(p_plan_id IN NUMBER) IS
1079: SELECT char_id , prompt_sequence
1080: , prompt, enabled_flag , default_value
1081: , default_value_id , result_column_name
1082: , 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
1083: , values_exist_flag, displayed_flag
1084: , char_name , datatype , display_length, hardcoded_column
1085: , developer_name , mandatory_flag
1086: FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;

Line 1407: , 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

1403: CURSOR get_plan_attributes_csr(p_plan_id IN NUMBER) IS
1404: SELECT char_id , prompt_sequence
1405: , prompt, enabled_flag , default_value
1406: , default_value_id , result_column_name
1407: , 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
1408: , values_exist_flag, displayed_flag
1409: , char_name , datatype , display_length, hardcoded_column
1410: , developer_name , mandatory_flag
1411: FROM QA_PLAN_CHARS_V WHERE plan_id = p_plan_id ORDER BY prompt_sequence;