APPS.PQH_GSP_UTILITY dependencies on PQH_ATTRIBUTES

Line 391: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

387: if p_gsp_node = '1' then
388: st_icon := 'Y';
389: else
390: select nvl(pa.decode_function_name, '99') into prev_task from
391: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
392: where
393: bcer.table_route_id = ptr.table_route_id
394: and ptr.table_route_id = pa.master_table_route_id
395: and ptr.table_alias = l_table_alias

Line 447: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

443:
444: End If;
445: if p_gsp_node = '1' then
446: select bcer.information100 into st_icon from
447: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
448: where
449: bcer.table_route_id = ptr.table_route_id
450: and ptr.table_route_id = pa.master_table_route_id
451: and ptr.table_alias = l_table_alias

Line 456: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

452: and pa.attribute_name = p_gsp_node
453: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
454: elsif p_gsp_node = '2' then
455: select bcer.information101 into st_icon from
456: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
457: where
458: bcer.table_route_id = ptr.table_route_id
459: and ptr.table_route_id = pa.master_table_route_id
460: and ptr.table_alias = l_table_alias

Line 465: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

461: and pa.attribute_name = p_gsp_node
462: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
463: elsif p_gsp_node = '3' then
464: select bcer.information102 into st_icon from
465: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
466: where
467: bcer.table_route_id = ptr.table_route_id
468: and ptr.table_route_id = pa.master_table_route_id
469: and ptr.table_alias = l_table_alias

Line 474: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

470: and pa.attribute_name = p_gsp_node
471: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
472: elsif p_gsp_node = '4'then
473: select bcer.information103 into st_icon from
474: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
475: where
476: bcer.table_route_id = ptr.table_route_id
477: and ptr.table_route_id = pa.master_table_route_id
478: and ptr.table_alias = l_table_alias

Line 483: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

479: and pa.attribute_name = p_gsp_node
480: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
481: elsif p_gsp_node = '5' then
482: select bcer.information104 into st_icon from
483: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
484: where
485: bcer.table_route_id = ptr.table_route_id
486: and ptr.table_route_id = pa.master_table_route_id
487: and ptr.table_alias = l_table_alias

Line 492: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

488: and pa.attribute_name = p_gsp_node
489: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
490: elsif p_gsp_node = '6' then
491: select bcer.information105 into st_icon from
492: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
493: where
494: bcer.table_route_id = ptr.table_route_id
495: and ptr.table_route_id = pa.master_table_route_id
496: and ptr.table_alias = l_table_alias

Line 501: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa

497: and pa.attribute_name = p_gsp_node
498: and bcer.copy_entity_txn_id = p_copy_enty_txn_id;
499: elsif p_gsp_node = '7' then
500: select bcer.information106 into st_icon from
501: ben_copy_entity_results bcer, pqh_table_route ptr, pqh_attributes pa
502: where
503: bcer.table_route_id = ptr.table_route_id
504: and ptr.table_route_id = pa.master_table_route_id
505: and ptr.table_alias = l_table_alias