APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_CHAT_OBJ_INCLUSIONS

Line 77: from ota_chat_obj_inclusions i,

73: c1.parent_cat_usage_id as parent_cat_usage_id_1,
74: c2.parent_cat_usage_id as parent_cat_usage_id_2,
75: c3.parent_cat_usage_id as parent_cat_usage_id_3,
76: c4.parent_cat_usage_id as parent_cat_usage_id_4
77: from ota_chat_obj_inclusions i,
78: ota_category_usages c1,
79: ota_category_usages c2,
80: ota_category_usages c3,
81: ota_category_usages c4

Line 1694: l_object_id ota_chat_obj_inclusions.object_id%type;

1690: p_chat_id in ota_chats_b.chat_id%type,
1691: p_self_enroll_only in varchar2) return varchar2 is
1692:
1693: l_now date := sysdate;
1694: l_object_id ota_chat_obj_inclusions.object_id%type;
1695: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
1696: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
1697: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;
1698: l_parent_cat_usage_id_4 ota_category_usages.category_usage_id%type;

Line 1745: l_object_id ota_chat_obj_inclusions.object_id%type;

1741: p_party_id in hz_parties.party_id%type,
1742: p_chat_id in ota_chats_b.chat_id%type,
1743: p_self_enroll_only in varchar2) return varchar2 is
1744:
1745: l_object_id ota_chat_obj_inclusions.object_id%type;
1746: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;
1747: l_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type;
1748: l_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type;
1749: l_parent_cat_usage_id_4 ota_category_usages.category_usage_id%type;