[Home] [Help]
506: if p_gsp_node = '1' then
507: st_icon := 'Y';
508: else
509: select nvl(pa.decode_function_name, '99') into prev_task from
510: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
511: where
512: bcer.table_route_id = ptr.table_route_id
513: and ptr.table_route_id = pa.master_table_route_id
514: and ptr.table_alias = l_table_alias
562:
563: End If;
564: if p_gsp_node = '1' then
565: select bcer.information100 into st_icon from
566: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
567: where
568: bcer.table_route_id = ptr.table_route_id
569: and ptr.table_route_id = pa.master_table_route_id
570: and ptr.table_alias = l_table_alias
571: and pa.attribute_name = p_gsp_node
572: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
573: elsif p_gsp_node = '2' then
574: select bcer.information101 into st_icon from
575: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
576: where
577: bcer.table_route_id = ptr.table_route_id
578: and ptr.table_route_id = pa.master_table_route_id
579: and ptr.table_alias = l_table_alias
580: and pa.attribute_name = p_gsp_node
581: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
582: elsif p_gsp_node = '3' then
583: select bcer.information102 into st_icon from
584: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
585: where
586: bcer.table_route_id = ptr.table_route_id
587: and ptr.table_route_id = pa.master_table_route_id
588: and ptr.table_alias = l_table_alias
589: and pa.attribute_name = p_gsp_node
590: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
591: elsif p_gsp_node = '4'then
592: select bcer.information103 into st_icon from
593: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
594: where
595: bcer.table_route_id = ptr.table_route_id
596: and ptr.table_route_id = pa.master_table_route_id
597: and ptr.table_alias = l_table_alias
598: and pa.attribute_name = p_gsp_node
599: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
600: elsif p_gsp_node = '5' then
601: select bcer.information104 into st_icon from
602: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
603: where
604: bcer.table_route_id = ptr.table_route_id
605: and ptr.table_route_id = pa.master_table_route_id
606: and ptr.table_alias = l_table_alias
607: and pa.attribute_name = p_gsp_node
608: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
609: elsif p_gsp_node = '6' then
610: select bcer.information105 into st_icon from
611: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
612: where
613: bcer.table_route_id = ptr.table_route_id
614: and ptr.table_route_id = pa.master_table_route_id
615: and ptr.table_alias = l_table_alias
616: and pa.attribute_name = p_gsp_node
617: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
618: elsif p_gsp_node = '7' then
619: select bcer.information106 into st_icon from
620: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
621: where
622: bcer.table_route_id = ptr.table_route_id
623: and ptr.table_route_id = pa.master_table_route_id
624: and ptr.table_alias = l_table_alias
1315: And Table_Alias = 'COP');
1316:
1317: Cursor csr_table_name IS
1318: Select Substr(Display_name,1,50)
1319: From Pqh_table_Route
1320: Where Table_Alias = p_Table_Alias;
1321:
1322: l_proc varchar2(72) := g_package||'GET_STEP_PRG_RULE_HGRID_NAME';
1323: l_step_or_point Varchar2(40);