[Home] [Help]
4697: AND enabled_flag = 'Y';
4698:
4699: CURSOR c_get_list_src_fld_data (p_data_source_code IN VARCHAR2, l_list_source_field_id IN NUMBER) IS
4700: SELECT source_column_name
4701: FROM ams_list_src_fields
4702: WHERE de_list_source_type_code = p_data_source_code
4703: AND list_source_field_id = l_list_source_field_id
4704: AND enabled_flag = 'Y';
4705:
5663: l_data_src_cnt NUMBER ;
5664: --
5665: CURSOR c_data_src_codes IS
5666: SELECT DISTINCT de_list_source_type_code
5667: FROM ams_list_src_fields
5668: WHERE list_source_field_id IN
5669: (SELECT profile_field_id
5670: FROM ams_cpag_questions_b
5671: WHERE content_item_id = p_section_citem_id
5672: ) ;
5673: --
5674: CURSOR c_data_src_flds IS
5675: SELECT ques.profile_field_id
5676: FROM ams_cpag_questions_b ques, ams_list_src_fields flds
5677: WHERE ques.profile_field_id = flds.list_source_field_id
5678: AND flds.de_list_source_type_code = l_data_src_type_code
5679: AND ques.content_item_id = p_section_citem_id ;
5680: --
5808:
5809: -- Find out all the Data Sources that are used by the questions section.
5810: -- We have the profile_field_id fields in Questions table.
5811: -- select distinct de_list_source_type_code
5812: -- from ams_list_src_fields
5813: -- where list_source_field_id in
5814: -- (select profile_field_id
5815: -- from ams_cpag_questions_b
5816: -- where content_item_id =
5837:
5838: -- For this data source, pick all the questions that fall in this
5839: -- data source and make a list to send to generate_select_sql
5840: -- select ques.profile_field_id
5841: -- from ams_cpag_questions_b ques, ams_list_src_fields flds
5842: -- where ques.profile_field_id = flds.list_source_field_id
5843: -- and flds.de_list_source_type_code =
5844:
5845: l_fld_cnt := 0;