APPS.AMS_CPAGEUTILITY_PVT dependencies on AMS_CPAG_QUESTIONS_B

Line 5654: FROM ams_cpag_questions_b

5650: WHERE deliverable_id = p_delv_id ;
5651: --
5652: CURSOR c_profile_ques_count IS
5653: SELECT count(1)
5654: FROM ams_cpag_questions_b
5655: WHERE content_item_id = p_section_citem_id
5656: AND profile_field_id IS NOT NULL
5657: AND question_type NOT IN (G_QUESTIONNAIRE, G_SEPARATOR) ;
5658: --

Line 5670: FROM ams_cpag_questions_b

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

Line 5676: FROM ams_cpag_questions_b ques, ams_list_src_fields flds

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: --

Line 5815: -- from ams_cpag_questions_b

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 =
5817: -- )
5818:
5819: OPEN c_data_src_codes ;

Line 5841: -- from ams_cpag_questions_b ques, ams_list_src_fields flds

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;