473: , x_calc_sql_exp_id
474: , calc_sql_exp_id
475: , 'EE'
476: , SYSDATE
477: , fnd_global.user_id
478: , fnd_global.login_id
479: , SYSDATE
480: , fnd_global.user_id
481: FROM cn_calc_sql_exps
474: , calc_sql_exp_id
475: , 'EE'
476: , SYSDATE
477: , fnd_global.user_id
478: , fnd_global.login_id
479: , SYSDATE
480: , fnd_global.user_id
481: FROM cn_calc_sql_exps
482: WHERE NAME = l_token
476: , SYSDATE
477: , fnd_global.user_id
478: , fnd_global.login_id
479: , SYSDATE
480: , fnd_global.user_id
481: FROM cn_calc_sql_exps
482: WHERE NAME = l_token
483: AND org_id=p_org_id;
484: ELSIF(INSTR(p_piped_sql_select, 'cn_formula', l_select_start, 1) = l_select_start) THEN
507: , x_calc_sql_exp_id
508: , l_calc_formula_id
509: , 'FE'
510: , SYSDATE
511: , fnd_global.user_id
512: , fnd_global.login_id
513: , SYSDATE
514: , fnd_global.user_id
515: );
508: , l_calc_formula_id
509: , 'FE'
510: , SYSDATE
511: , fnd_global.user_id
512: , fnd_global.login_id
513: , SYSDATE
514: , fnd_global.user_id
515: );
516: END IF;
510: , SYSDATE
511: , fnd_global.user_id
512: , fnd_global.login_id
513: , SYSDATE
514: , fnd_global.user_id
515: );
516: END IF;
517:
518: l_select_start := l_select_end + 1;
787: , p_calc_sql_exp_id
788: , calc_sql_exp_id
789: , 'EE'
790: , SYSDATE
791: , fnd_global.user_id
792: , fnd_global.login_id
793: , SYSDATE
794: , fnd_global.user_id
795: FROM cn_calc_sql_exps
788: , calc_sql_exp_id
789: , 'EE'
790: , SYSDATE
791: , fnd_global.user_id
792: , fnd_global.login_id
793: , SYSDATE
794: , fnd_global.user_id
795: FROM cn_calc_sql_exps
796: WHERE NAME = l_token
790: , SYSDATE
791: , fnd_global.user_id
792: , fnd_global.login_id
793: , SYSDATE
794: , fnd_global.user_id
795: FROM cn_calc_sql_exps
796: WHERE NAME = l_token
797: AND org_id= p_org_id
798: AND NOT EXISTS(
828: , p_calc_sql_exp_id
829: , l_calc_formula_id
830: , 'FE'
831: , SYSDATE
832: , fnd_global.user_id
833: , fnd_global.login_id
834: , SYSDATE
835: , fnd_global.user_id
836: FROM DUAL
829: , l_calc_formula_id
830: , 'FE'
831: , SYSDATE
832: , fnd_global.user_id
833: , fnd_global.login_id
834: , SYSDATE
835: , fnd_global.user_id
836: FROM DUAL
837: WHERE NOT EXISTS(
831: , SYSDATE
832: , fnd_global.user_id
833: , fnd_global.login_id
834: , SYSDATE
835: , fnd_global.user_id
836: FROM DUAL
837: WHERE NOT EXISTS(
838: SELECT 1
839: FROM cn_calc_edges