DBA Data[Home] [Help]

APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on JA_CN_FA_CATEGORY_GT

Line 179: FROM ja_cn_fa_category_gt jcfc

175: CURSOR filtered_category_cur IS
176: SELECT DISTINCT
177: jcfc.category_code,
178: jcfc.category_name
179: FROM ja_cn_fa_category_gt jcfc
180: ORDER BY jcfc.category_code;
181:
182: BEGIN
183: --logging for debug

Line 303: INSERT INTO ja_cn_fa_category_gt

299: CLOSE category_code_name_cur;
300: lv_combined_category_code := lv_combined_category_code || lv_category_value;
301:
302: -- insert into the temporary table in order to filter the same
303: INSERT INTO ja_cn_fa_category_gt
304: (category_code
305: ,category_name
306: ,created_by
307: ,creation_date

Line 330: INSERT INTO ja_cn_fa_category_gt

326: THEN
327: lv_combined_category_code := lv_combined_category_code || lv_category_value;
328:
329: -- insert into the temporary table in order to filter the same
330: INSERT INTO ja_cn_fa_category_gt
331: (category_code
332: ,category_name
333: ,created_by
334: ,creation_date