[Home] [Help]
216: BEGIN
217: SELECT /*+ FIRST_ROWS */
218: 1
219: INTO org_override
220: FROM sys.dual WHERE EXISTS
221: (SELECT /*+ FIRST_ROWS */
222: 1
223: FROM pa_ind_cost_multipliers
224: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
337: x_program_application_id,
338: x_program_id,
339: SYSDATE,
340: 'A'
341: FROM DUAL
342: WHERE NOT EXISTS
343: ( SELECT 1 from pa_ind_compiled_sets ics
344: WHERE ics.ind_rate_sch_revision_id =rate_sch_rev_id
345: AND ics.organization_id = org_id
398: BEGIN
399: SELECT /*+ FIRST_ROWS */
400: 1
401: INTO l_org_override
402: FROM sys.dual WHERE EXISTS
403: (SELECT /*+ FIRST_ROWS */
404: 1
405: FROM pa_ind_cost_multipliers icm,
406: pa_ind_compiled_sets ics
443: --
444:
445: stage := 200;
446:
447: SELECT pa_ind_compiled_sets_s.NEXTVAL into compiled_set_id FROM sys.dual;
448:
449:
450: SAVEPOINT before_adding_multipliers;
451:
703: x_program_application_id,
704: x_program_id,
705: SYSDATE,
706: 'A'
707: FROM DUAL
708: WHERE NOT EXISTS
709: ( SELECT 1 from pa_ind_compiled_sets ics
710: WHERE ics.ind_rate_sch_revision_id =rate_sch_rev_id
711: AND ics.organization_id = org_id
954: AND org_structure_version_id = ver_id
955: START WITH organization_id_parent = l_org_id
956: AND org_structure_version_id = ver_id
957: UNION ALL
958: SELECT 0,l_org_id organization_id FROM dual
959: ORDER BY 1;
960:
961: BEGIN
962:
1320: FOR base_rec in all_cost_bases
1321: LOOP
1322: select 1
1323: into l_check
1324: from sys.dual
1325: where exists(select 1
1326: from pa_ind_compiled_sets
1327: where ind_rate_sch_revision_id =G_RATE_SCH_REVISION_ID /* 4527736 */
1328: and organization_id =start_org
3822: * also.
3823: */
3824:
3825: --S.O. /*Bug 4527736 */
3826: -- SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
3827: -- (SELECT 1 FROM pa_ind_compiled_sets ICS, /* Removed Hint NO_INDEX(ITEM PA_EXPENDITURE_ITEMS_N13) */
3828: -- pa_expenditure_items_all ITEM
3829: -- WHERE
3830: -- ICS.ind_rate_sch_revision_id = rate_sch_rev_id
3833: -- OR (ICS.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id)
3834: -- OR (ICS.ind_compiled_set_id = ITEM.inv_ind_compiled_set_id)));
3835: --E.O. /*Bug 4527736 */
3836: --S.N. /*Bug 4527736 */
3837: SELECT 1 INTO dummy FROM SYS.DUAL
3838: WHERE NOT EXISTS
3839: (SELECT 1
3840: FROM PA_IND_COMPILED_SETS ICS
3841: WHERE ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id
3992: end if;
3993:
3994:
3995: for icc_row in icc_cursor loop
3996: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
3997:
3998: INSERT INTO pa_cost_base_cost_codes
3999: (cost_base_cost_code_id,
4000: cost_plus_structure,
7008: AND org_structure_version_id = ver_id
7009: START WITH organization_id_parent = org_id
7010: AND org_structure_version_id = ver_id
7011: UNION
7012: select org_id from dual ;
7013:
7014: -- Standard who
7015: x_last_updated_by NUMBER(15);
7016: x_last_update_login NUMBER(15);
7472: AND org_structure_version_id = ver_id
7473: START WITH organization_id_parent = org_id
7474: AND org_structure_version_id = ver_id
7475: UNION
7476: select org_id from dual ;
7477:
7478: BEGIN
7479: --
7480: -- Remove redundant compiled sets and multipiers.
7691: LOOP
7692: BEGIN
7693: /* Modified for 14330754
7694: select 1 into org_override
7695: from sys.dual
7696: where exists(*/
7697: select /*+ use_nl(ICS) */ 1 into org_override
7698: from pa_ind_cost_multipliers icm ,
7699: pa_ind_compiled_sets ics
7717: WHEN NO_DATA_FOUND THEN
7718: BEGIN /* Code change for Bug 4739218 Starts */
7719: --Bug 10057189 Rewriting the below SQL for performance tuning
7720: /*select 0 into org_override
7721: from sys.dual
7722: where exists
7723: (
7724: select 1
7725: from pa_ind_cost_multipliers icm ,