APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on JTF_RS_GROUPS_DENORM

Line 108: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'

104: -- Check some ther index which will definitly exist
105: SELECT owner, table_owner, tablespace_name
106: INTO l_index_owner, l_table_owner, l_index_tblspace
107: FROM ALL_INDEXES
108: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
109: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
110: AND table_owner= l_jtfu;
111: END;
112:

Line 109: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'

105: SELECT owner, table_owner, tablespace_name
106: INTO l_index_owner, l_table_owner, l_index_tblspace
107: FROM ALL_INDEXES
108: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
109: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
110: AND table_owner= l_jtfu;
111: END;
112:
113: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner

Line 219: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1

215: '0-FIRST-TIME-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval
216: ,'N' mem_flag , 'A' mem_status
217: ,l_sysdate, l_user_id
218: ,DECODE(d1.active_flag,'Y','Y','N')
219: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1
220: WHERE n1.group_id = d1.actual_parent_id
221: AND d1.denorm_level < 2
222: AND d1.latest_relationship_flag = 'Y'
223: ;

Line 257: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,

253: jtf_rs_dbi_denorm_res_groups_s.nextval
254: ,'N' mem_flag , 'A' mem_status
255: ,l_sysdate, l_user_id
256: ,DECODE(d1.active_flag,'Y','Y','N')
257: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,
258: jtf_rs_dbi_mgr_groups n1
259: WHERE n1.group_id = d1.parent_group_id
260: AND d1.group_id = d2.actual_parent_id
261: AND n1.group_id = d2.parent_group_id

Line 299: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

295: jtf_rs_dbi_denorm_res_groups_s.nextval
296: ,'N' mem_flag , 'A' mem_status
297: ,l_sysdate, l_user_id
298: ,DECODE(d1.active_flag,'Y','Y','N')
299: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
300: WHERE n1.group_id = d1.parent_group_id
301: AND d1.latest_relationship_flag = 'Y'
302: ;
303:

Line 336: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

332: , jtf_rs_dbi_denorm_res_groups_s.nextval
333: ,'N' mem_flag , 'A' mem_status
334: ,l_sysdate, l_user_id
335: ,DECODE(d1.active_flag,'Y','Y','N')
336: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
337: WHERE n1.group_id = d1.parent_group_id
338: AND d1.denorm_level > 0
339: AND d1.latest_relationship_flag = 'Y'
340: ;

Line 381: FROM jtf_rs_groups_denorm d1,

377: drg1.user_id, drg1.resource_id, 'B-PEER' DEBUG_COLUMN , jtf_rs_dbi_denorm_res_groups_s.nextval
378: ,'N' mem_flag , 'A' mem_status
379: ,l_sysdate, l_user_id
380: ,DECODE(d1.active_flag,'Y','Y','N') active_grp_rel_only
381: FROM jtf_rs_groups_denorm d1,
382: jtf_rs_dbi_denorm_res_groups drg1
383: WHERE drg1.current_id = drg1.id
384: AND drg1.denorm_level > 0
385: AND drg1.parent_id = d1.parent_group_id