APPS.CS_TP_CHOICES_PVT dependencies on CS_TP_LOOKUPS

Line 24: select count (*) from CS_TP_LOOKUPS where LOOKUP_ID = p_One_Choice.mLookupID;

20: is
21: l_api_name CONSTANT VARCHAR2(30) := 'Add_Choice';
22: l_api_version CONSTANT NUMBER := 1.0;
23: Cursor LookupC is
24: select count (*) from CS_TP_LOOKUPS where LOOKUP_ID = p_One_Choice.mLookupID;
25: l_lookup_count NUMBER;
26: l_choice_id NUMBER;
27: l_ROWID VARCHAR2(30);
28: Cursor C is

Line 528: select count (*) from CS_TP_LOOKUPS where LOOKUP_ID = p_One_Freetext.mLookupID;

524: l_api_name CONSTANT VARCHAR2(30) := 'Add_Freetext';
525: l_api_version CONSTANT NUMBER := 1.0;
526:
527: Cursor LookupC is
528: select count (*) from CS_TP_LOOKUPS where LOOKUP_ID = p_One_Freetext.mLookupID;
529: Cursor FreetextC is
530: select FREETEXT_ID from CS_TP_FREETEXTS where LOOKUP_ID= p_One_Freetext.mLookupID;
531:
532:

Line 652: cs_tp_lookups flkup

648: ftxt.lookup_id,
649: ftxt.last_update_date,
650: flkup.default_value
651: FROM cs_tp_freetexts ftxt,
652: cs_tp_lookups flkup
653: WHERE flkup.lookup_id = p_lookup_id
654: AND ftxt.lookup_id = flkup.lookup_id;
655:
656: l_freetext freetextC%ROWTYPE;