APPS.EC_CODE_CONVERSION_PVT dependencies on ECE_XREF_CATEGORIES

Line 955: FROM ece_xref_categories

951: ckey4_used_table, ckey5_used_table,
952: ckey1_used_column, ckey2_used_column, ckey3_used_column,
953: ckey4_used_column, ckey5_used_column,
954: cxref_category_code
955: FROM ece_xref_categories
956: WHERE ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;
957:
958: IF ckey1_used_flag = 'Y' AND
959: p_tbl(i).xref_key1_source_column IS NOT NULL THEN

Line 956: WHERE ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;

952: ckey1_used_column, ckey2_used_column, ckey3_used_column,
953: ckey4_used_column, ckey5_used_column,
954: cxref_category_code
955: FROM ece_xref_categories
956: WHERE ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;
957:
958: IF ckey1_used_flag = 'Y' AND
959: p_tbl(i).xref_key1_source_column IS NOT NULL THEN
960: FOR j IN 1..p_key_tbl.count LOOP

Line 1325: FROM ece_xref_categories

1321: ckey4_used_table, ckey5_used_table,
1322: ckey1_used_column, ckey2_used_column, ckey3_used_column,
1323: ckey4_used_column, ckey5_used_column,
1324: cxref_category_code
1325: FROM ece_xref_categories
1326: WHERE ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;
1327:
1328: -- Bug 2828072
1329: IF ckey1_used_flag = 'Y' AND

Line 1326: WHERE ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;

1322: ckey1_used_column, ckey2_used_column, ckey3_used_column,
1323: ckey4_used_column, ckey5_used_column,
1324: cxref_category_code
1325: FROM ece_xref_categories
1326: WHERE ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;
1327:
1328: -- Bug 2828072
1329: IF ckey1_used_flag = 'Y' AND
1330: p_tbl(i).xref_key1_source_column IS NOT NULL THEN

Line 1836: FROM ece_xref_categories

1832: ckey4_used_table, ckey5_used_table,
1833: ckey1_used_column, ckey2_used_column, ckey3_used_column,
1834: ckey4_used_column, ckey5_used_column,
1835: cxref_category_code
1836: FROM ece_xref_categories
1837: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
1838:
1839: IF ckey1_used_flag = 'Y' AND
1840: p_apps_tbl(j).xref_key1_source_column IS NOT NULL THEN

Line 1837: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;

1833: ckey1_used_column, ckey2_used_column, ckey3_used_column,
1834: ckey4_used_column, ckey5_used_column,
1835: cxref_category_code
1836: FROM ece_xref_categories
1837: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
1838:
1839: IF ckey1_used_flag = 'Y' AND
1840: p_apps_tbl(j).xref_key1_source_column IS NOT NULL THEN
1841: FOR k IN 1..p_key_tbl.count LOOP

Line 2301: FROM ece_xref_categories

2297: ckey4_used_table, ckey5_used_table,
2298: ckey1_used_column, ckey2_used_column, ckey3_used_column,
2299: ckey4_used_column, ckey5_used_column,
2300: cxref_category_code
2301: FROM ece_xref_categories
2302: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
2303: if EC_DEBUG.G_debug_level >= 3 then
2304: ec_debug.pl(3,'xref_category_id',p_apps_tbl(j).xref_category_id);
2305: ec_debug.pl(3,'cxref_category_code',cxref_category_code);

Line 2302: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;

2298: ckey1_used_column, ckey2_used_column, ckey3_used_column,
2299: ckey4_used_column, ckey5_used_column,
2300: cxref_category_code
2301: FROM ece_xref_categories
2302: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
2303: if EC_DEBUG.G_debug_level >= 3 then
2304: ec_debug.pl(3,'xref_category_id',p_apps_tbl(j).xref_category_id);
2305: ec_debug.pl(3,'cxref_category_code',cxref_category_code);
2306: end if;