APPS.FII_SETUP_VAL_C dependencies on DUAL

Line 186: FROM dual

182: l_cnt NUMBER;
183:
184: CURSOR mgr_status_cur(user_id NUMBER) IS
185: SELECT 1
186: FROM dual
187: WHERE NOT EXISTS (
188: SELECT DISTINCT suph.sup_person_id
189: FROM (SELECT to_number (mgr_tbl.org_information2) manager,
190: ccc_tbl.organization_id ccc_org_id

Line 476: from dual

472: where dbi_enabled_flag = 'Y';
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'

Line 481: 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
482: where not exists (select 1 from fii_fin_cat_type_assgns
483: where fin_cat_type_code = 'OE')
484: union
485: select 'TE'

Line 486: 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
487: where not exists (select 1 from fii_fin_cat_type_assgns
488: where fin_cat_type_code = 'TE')
489: union
490: select 'CGS'

Line 491: 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
492: where not exists (select 1 from fii_fin_cat_type_assgns
493: where fin_cat_type_code = 'CGS')
494: union
495: select 'DR'

Line 496: 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
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

Line 857: FROM dual;

853:
854: -- Retrive current system time as the start time of the program
855: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'), sysdate
856: INTO l_start_time, l_sys_date
857: FROM dual;
858:
859: -----------------------------------------------------------------------
860: -- Print report header in logfile
861: -----------------------------------------------------------------------

Line 2274: FROM dual;

2270: -----------------------------------------------------------------------
2271: -- Retrive current system time as the end time of the program
2272: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2273: INTO l_end_time
2274: FROM dual;
2275:
2276: fii_util.put_line(' ');
2277: fii_util.put_line('** Diagnostics Ends ** '|| l_end_time);
2278: fii_util.put_line(