APPS.BIL_OBI_GROUPS_DENORM_PKG dependencies on JTF_RS_GROUPS_DENORM

Line 80: from jtf_rs_groups_denorm j, jtf_rs_group_usages u

76: from
77: (select j.denorm_grp_id, j.group_id, j.parent_group_id, j.created_by, j.creation_date,j.last_updated_by,
78: j.last_update_date,j.last_update_login, j.immediate_parent_flag, j.start_date_active, j.end_date_active,
79: j.active_flag, j.denorm_level
80: from jtf_rs_groups_denorm j, jtf_rs_group_usages u
81: where j.group_id = u.group_id
82: and u.usage = 'SALES'
83: and latest_relationship_flag = 'Y'
84: order by group_id, denorm_level))))));

Line 95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');

91: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
92: bil_bi_util_collection_pkg.writeLog(
93: p_log_level => fnd_log.LEVEL_EVENT,
94: p_module => g_pkg || l_proc ,
95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');
96: END IF;
97:
98: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
99: bil_bi_util_collection_pkg.writeLog(