276:
277: -- Get object's database_object_name and primary key
278: select ao.database_object_name, ao.primary_key_name
279: into root.database_object_name, root.primary_key_name
280: from ak_objects ao,
281: ak_regions ar
282: where ar.region_code = root.region_code
283: and ar.region_application_id = root.region_application_id
284: and ar.database_object_name = ao.database_object_name;
631: ak_regions ar1,
632: ak_regions ar2,
633: ak_flow_page_regions afpr1,
634: ak_flow_page_regions afpr2,
635: ak_objects ao1,
636: ak_objects ao2,
637: ak_foreign_keys afk
638: WHERE afrr.flow_application_id = flow_appl_id_param
639: AND afrr.flow_code = flow_code_param
632: ak_regions ar2,
633: ak_flow_page_regions afpr1,
634: ak_flow_page_regions afpr2,
635: ak_objects ao1,
636: ak_objects ao2,
637: ak_foreign_keys afk
638: WHERE afrr.flow_application_id = flow_appl_id_param
639: AND afrr.flow_code = flow_code_param
640: AND afrr.from_page_appl_id = from_page_appl_id_param
1921: l_display_sequence
1922: FROM ak_flow_page_regions fpr,
1923: ak_regions ar,
1924: ak_regions_tl art,
1925: ak_objects ao
1926: WHERE fpr.flow_application_id = p_region_rec.flow_application_id
1927: AND fpr.flow_code = p_region_rec.flow_code
1928: AND fpr.page_application_id = p_region_rec.page_application_id
1929: AND fpr.page_code = p_region_rec.page_code
1966: l_region_defaulting_api_proc,
1967: l_display_sequence
1968: FROM ak_regions ar,
1969: ak_regions_tl art,
1970: ak_objects ao
1971: WHERE ar.region_application_id = p_region_rec.region_application_id
1972: AND ar.region_code = p_region_rec.region_code
1973: AND art.region_application_id = ar.region_application_id
1974: AND art.region_code = ar.region_code