APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_CHOICES_VL

Line 80: /* Cursor to query record from CS_TP_CHOICES_VL for deleting records from choices */

76: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
77: and trunc(nvl(end_date_active,sysdate))
78: AND language = userenv('LANG');
79:
80: /* Cursor to query record from CS_TP_CHOICES_VL for deleting records from choices */
81: cursor c_tp_choice (p_lookup_id number) IS
82: select choice_id, value, default_choice_flag
83: from cs_tp_choices_vl
84: where lookup_id = p_lookup_id;

Line 83: from cs_tp_choices_vl

79:
80: /* Cursor to query record from CS_TP_CHOICES_VL for deleting records from choices */
81: cursor c_tp_choice (p_lookup_id number) IS
82: select choice_id, value, default_choice_flag
83: from cs_tp_choices_vl
84: where lookup_id = p_lookup_id;
85:
86: /* Cursor to query record from CS_TP_FREETEXTS for deleting records from freetext */
87: cursor c_tp_freetext (p_lookup_id number) IS

Line 599: from cs_tp_choices_vl

595: Cursor c_tp_choice (p_lookup_id number) is
596: select choice_id
597: , lookup_id
598: , value
599: from cs_tp_choices_vl
600: where lookup_id = p_lookup_id;
601:
602: /* Define recordtypes for the above cursor */
603: l_cug_sr_attr_ListName c_cug_sr_attr_ListName%ROWTYPE;