APPS.FII_SETUP_VAL_C dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 477: where not exists (select 1 from fii_fin_cat_type_assgns

473:
474: CURSOR fin_type_cur IS
475: select 'R'
476: from dual
477: where not exists (select 1 from fii_fin_cat_type_assgns
478: where fin_cat_type_code = 'R')
479: union
480: select 'OE'
481: from dual

Line 482: where not exists (select 1 from fii_fin_cat_type_assgns

478: where fin_cat_type_code = 'R')
479: union
480: select 'OE'
481: from dual
482: where not exists (select 1 from fii_fin_cat_type_assgns
483: where fin_cat_type_code = 'OE')
484: union
485: select 'TE'
486: from dual

Line 487: where not exists (select 1 from fii_fin_cat_type_assgns

483: where fin_cat_type_code = 'OE')
484: union
485: select 'TE'
486: from dual
487: where not exists (select 1 from fii_fin_cat_type_assgns
488: where fin_cat_type_code = 'TE')
489: union
490: select 'CGS'
491: from dual

Line 492: where not exists (select 1 from fii_fin_cat_type_assgns

488: where fin_cat_type_code = 'TE')
489: union
490: select 'CGS'
491: from dual
492: where not exists (select 1 from fii_fin_cat_type_assgns
493: where fin_cat_type_code = 'CGS')
494: union
495: select 'DR'
496: from dual

Line 497: where not exists (select 1 from fii_fin_cat_type_assgns

493: where fin_cat_type_code = 'CGS')
494: union
495: select 'DR'
496: from dual
497: where not exists (select 1 from fii_fin_cat_type_assgns
498: where fin_cat_type_code = 'DR');
499:
500: --this cursor prints out all company, cost_center with no orgs assigned
501: Cursor no_org_cur is

Line 766: from fii_fin_cat_type_assgns fct

762: and fv1.flex_value_id = fgj.company_id
763: and fv2.flex_value_id = fgj.cost_center_id
764: and fcm.child_fin_cat_id = fgj.fin_category_id ) v
765: WHERE NOT EXISTS (select fct.fin_category_id
766: from fii_fin_cat_type_assgns fct
767: where fct.fin_category_id = v.fin_category_id))c,
768: fnd_flex_values d,
769: fnd_flex_value_sets e
770: WHERE a.application_id = 101