APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_GROUPS_DENORM

Line 214: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'

210: -- Check some ther index which will definitly exist
211: SELECT owner, table_owner, tablespace_name
212: INTO l_index_owner, l_table_owner, l_index_tblspace
213: FROM ALL_INDEXES
214: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
215: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
216: AND table_owner= l_jtfu;
217:
218: END;

Line 215: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'

211: SELECT owner, table_owner, tablespace_name
212: INTO l_index_owner, l_table_owner, l_index_tblspace
213: FROM ALL_INDEXES
214: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
215: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
216: AND table_owner= l_jtfu;
217:
218: END;
219:

Line 363: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1

359: ,'N' mem_flag , 'A' mem_status
360: ,l_sysdate, l_user_id
361: ,DECODE(d1.active_flag,'Y','Y','N')
362: ,l_sysdate, l_user_id, usg.usage
363: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1
364: , jtf_rs_group_usages usg
365: WHERE n1.group_id = d1.actual_parent_id
366: AND d1.denorm_level = 1
367: AND d1.latest_relationship_flag = 'Y'

Line 409: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,

405: ,'N' mem_flag , 'A' mem_status
406: ,l_sysdate, l_user_id
407: ,DECODE(d1.active_flag,'Y','Y','N')
408: ,l_sysdate, l_user_id, usg.usage
409: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,
410: jtf_rs_dbi_mgr_groups n1
411: ,jtf_rs_group_usages usg
412: WHERE n1.group_id = d1.parent_group_id
413: AND d1.group_id = d2.actual_parent_id

Line 459: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

455: ,'N' mem_flag , 'A' mem_status
456: ,l_sysdate, l_user_id
457: ,DECODE(d1.active_flag,'Y','Y','N')
458: ,l_sysdate, l_user_id, usg.usage
459: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
460: ,jtf_rs_group_usages usg
461: WHERE n1.group_id = d1.parent_group_id
462: AND d1.latest_relationship_flag = 'Y'
463: AND d1.group_id = usg.group_id

Line 504: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

500: ,'N' mem_flag , 'A' mem_status
501: ,l_sysdate, l_user_id
502: ,DECODE(d1.active_flag,'Y','Y','N')
503: ,l_sysdate, l_user_id, usg.usage
504: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
505: ,jtf_rs_group_usages usg
506: WHERE n1.group_id = d1.parent_group_id
507: AND d1.denorm_level > 0
508: AND d1.latest_relationship_flag = 'Y'