APPS.PA_EXCEPTION_ENGINE_PKG dependencies on DUAL

Line 473: SELECT count(*) INTO l_count FROM dual where EXISTS

469: ELSE
470: --- If bz_ent_code is not passed in, get one bz_ent_code
471: --- from pa_perf_bz_measures for the given measure id
472: IF (p_business_event_code = 'N') THEN
473: SELECT count(*) INTO l_count FROM dual where EXISTS
474: (SELECT bz_event_code
475: FROM pa_perf_bz_measures
476: WHERE measure_id = l_measure_id);
477: IF l_count = 0 THEN

Line 698: SELECT count(*) INTO l_count FROM dual where EXISTS

694: -- ELSE if business event is passed in, mark to be not current only the transactions with
695: -- measure_id associated with the business event
696: ELSE
697: --Check if there are records to be updated
698: SELECT count(*) INTO l_count FROM dual where EXISTS
699: (SELECT project_id
700: FROM pa_perf_transactions
701: --WHERE project_id = l_object_list(i) --Modified for Bug3639490
702: WHERE perf_txn_obj_type = 'PA_PROJECTS'

Line 1316: SELECT COUNT(*) INTO l_count FROM dual WHERE EXISTS

1312: IF P_PA_DEBUG_MODE = 'Y' THEN
1313: pa_debug.write_file('LOG', pa_debug.g_err_stage);
1314: END IF;
1315:
1316: SELECT COUNT(*) INTO l_count FROM dual WHERE EXISTS
1317: (
1318: SELECT pt.threshold_Id, pt.indicator_code, pt.exception_flag,
1319: pt.weighting, pt.from_value, pt.to_value
1320: FROM pa_perf_thresholds pt, pa_perf_rules pr

Line 1536: FROM DUAL;

1532: END IF;
1533:
1534: SELECT pa_perf_kpa_summary_s1.nextval
1535: INTO l_summary_seq
1536: FROM DUAL;
1537:
1538:
1539: l_summary_table.DELETE();
1540:

Line 1586: FROM dual;

1582: IF (l_rule_id IS NOT NULL) THEN
1583:
1584: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL
1585: INTO l_summary_det_seq
1586: FROM dual;
1587:
1588: IF P_PA_DEBUG_MODE = 'Y' THEN
1589: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');
1590: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));

Line 1694: FROM dual;

1690:
1691:
1692: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL
1693: INTO l_summary_det_seq
1694: FROM dual;
1695:
1696: IF P_PA_DEBUG_MODE = 'Y' THEN
1697: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');
1698: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));

Line 1827: FROM dual;

1823:
1824:
1825: SELECT pa_perf_kpa_summary_det_s1.NEXTVAL
1826: INTO l_summary_det_seq
1827: FROM dual;
1828:
1829: IF P_PA_DEBUG_MODE = 'Y' THEN
1830: PA_DEBUG.write_file('LOG', 'Inserting into PA_PERF_KPA_SUMMARY_DET');
1831: PA_DEBUG.write_file('LOG', 'KPA code : '||l_kpas(j));