eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_ENTITY_ATTRS

Line 2581: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr

2577: */
2578:
2579: CURSOR check_attr_exist(p_program_id NUMBER) IS
2580: SELECT 'X' from dual where exists( SELECT distinct(attr.attribute_id)
2581: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr
2582: WHERE arc_used_by_entity_code='PRGM'
2583: AND attr.ENTITY_ATTR_ID=qsnr.entity_attr_id
2584: AND used_by_entity_id in
2585: ( SELECT program_id

Line 2595: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr

2591:
2592:
2593: CURSOR attribute_id_csr(p_program_id NUMBER) IS
2594: SELECT distinct(attr.attribute_id)
2595: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr
2596: WHERE arc_used_by_entity_code='PRGM'
2597: AND attr.ENTITY_ATTR_ID=qsnr.entity_attr_id
2598: AND used_by_entity_id in
2599: ( SELECT program_id