APPS.ICX_ON_UTILITIES dependencies on AK_FLOW_REGION_RELATIONS

Line 923: from AK_FLOW_REGION_RELATIONS

919: select FLOW_APPLICATION_ID,FLOW_CODE,
920: TO_PAGE_APPL_ID,TO_PAGE_CODE
921: into l_flow_appl_id,l_flow_code,
922: c_to_page_appl_id,c_to_page_code
923: from AK_FLOW_REGION_RELATIONS
924: where ROWID = c_rowid;
925:
926: end if;
927:

Line 1003: from AK_FLOW_REGION_RELATIONS a,

999: c_from_region_code := r.REGION_CODE;
1000:
1001: select count(*)
1002: into l_row_count
1003: from AK_FLOW_REGION_RELATIONS a,
1004: AK_FOREIGN_KEYS b
1005: where a.FROM_REGION_CODE = c_from_region_code
1006: and a.FROM_REGION_APPL_ID = c_from_region_appl_id
1007: and a.FROM_PAGE_CODE = c_to_page_code

Line 1020: from AK_FLOW_REGION_RELATIONS a,

1016: select a.ROWID,b.UNIQUE_KEY_NAME,
1017: a.TO_PAGE_APPL_ID,a.TO_PAGE_CODE
1018: into c_rowid,c_unique_key_name,
1019: c_to_page_appl_id,c_to_page_code
1020: from AK_FLOW_REGION_RELATIONS a,
1021: AK_FOREIGN_KEYS b
1022: where a.FROM_REGION_CODE = c_from_region_code
1023: and a.FROM_REGION_APPL_ID = c_from_region_appl_id
1024: and a.FROM_PAGE_CODE = c_to_page_code

Line 1137: from AK_FLOW_REGION_RELATIONS

1133: select FROM_PAGE_APPL_ID,FROM_PAGE_CODE,
1134: FROM_REGION_APPL_ID,FROM_REGION_CODE
1135: into c_from_page_appl_id,c_from_page_code,
1136: c_from_region_appl_id,c_from_region_code
1137: from AK_FLOW_REGION_RELATIONS
1138: where ROWID = c_rowid;
1139:
1140: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1141: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);