DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT_DIST dependencies on AK_REGION_ITEMS

Line 1725: from ak_region_items a,

1721: l NUMBER := NULL;
1722:
1723: cursor get_ak_attributes is
1724: select ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME
1725: from ak_region_items a,
1726: ak_attributes b,
1727: ak_regions c,
1728: ak_object_attributes d
1729: where a.NODE_DISPLAY_FLAG = 'Y'

Line 1744: from ak_region_items a,

1740: order by a.display_sequence;
1741:
1742: cursor check_concatenated_segment is
1743: select 1
1744: from ak_region_items a,
1745: ak_attributes b,
1746: ak_regions c,
1747: ak_object_attributes d
1748: where a.NODE_DISPLAY_FLAG = 'Y'

Line 1962: FROM ak_region_items a,

1958:
1959: CURSOR get_ak_attributes IS
1960: SELECT ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME,
1961: a.UPDATE_FLAG UPDATE_FLAG
1962: FROM ak_region_items a,
1963: ak_attributes b,
1964: ak_regions c
1965: WHERE a.NODE_DISPLAY_FLAG = 'Y'
1966: AND a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE

Line 1997: FROM ak_region_items a,

1993: AND cart_line_id = v_cart_line_id;
1994:
1995: CURSOR check_concatenated_segment IS
1996: SELECT 1
1997: FROM ak_region_items a,
1998: ak_attributes b,
1999: ak_regions c,
2000: ak_object_attributes d
2001: WHERE a.NODE_DISPLAY_FLAG = 'Y'