APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_GROUPS_DENORM

Line 217: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'

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

Line 218: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'

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

Line 370: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1

366: ,'N' mem_flag , 'A' mem_status
367: ,l_sysdate, l_user_id
368: ,DECODE(d1.active_flag,'Y','Y','N')
369: ,l_sysdate, l_user_id, usg.usage
370: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1
371: , jtf_rs_group_usages usg
372: WHERE n1.group_id = d1.actual_parent_id
373: AND d1.denorm_level = 1
374: AND d1.latest_relationship_flag = 'Y'

Line 416: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,

412: ,'N' mem_flag , 'A' mem_status
413: ,l_sysdate, l_user_id
414: ,DECODE(d1.active_flag,'Y','Y','N')
415: ,l_sysdate, l_user_id, usg.usage
416: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,
417: jtf_rs_dbi_mgr_groups n1
418: ,jtf_rs_group_usages usg
419: WHERE n1.group_id = d1.parent_group_id
420: AND d1.group_id = d2.actual_parent_id

Line 466: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

462: ,'N' mem_flag , 'A' mem_status
463: ,l_sysdate, l_user_id
464: ,DECODE(d1.active_flag,'Y','Y','N')
465: ,l_sysdate, l_user_id, usg.usage
466: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
467: ,jtf_rs_group_usages usg
468: WHERE n1.group_id = d1.parent_group_id
469: AND d1.latest_relationship_flag = 'Y'
470: AND d1.group_id = usg.group_id

Line 511: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

507: ,'N' mem_flag , 'A' mem_status
508: ,l_sysdate, l_user_id
509: ,DECODE(d1.active_flag,'Y','Y','N')
510: ,l_sysdate, l_user_id, usg.usage
511: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
512: ,jtf_rs_group_usages usg
513: WHERE n1.group_id = d1.parent_group_id
514: AND d1.denorm_level > 0
515: AND d1.latest_relationship_flag = 'Y'