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.PQH_CORPS_UTILITY dependencies on PQH_CORPS_DEFINITIONS

Line 404: FROM pqh_corps_definitions

400: IS
401:
402: Cursor csr_corps_pgm_exists IS
403: SELECT 'Y'
404: FROM pqh_corps_definitions
405: WHERE ben_pgm_id = p_pgm_id;
406:
407:
408: l_exist Varchar2(1) := 'N';

Line 428: FROM pqh_corps_definitions

424: CURSOR csr_if_prim_prof_field IS
425: SELECT 'Y'
426: FROM dual
427: WHERE EXISTS (SELECT 1
428: FROM pqh_corps_definitions
429: WHERE corps_definition_id = p_corps_definition_id
430: AND nvl(primary_prof_field_id,-1) = p_field_of_prof_activity_id);
431: l_primary varchar2(10) := 'N';
432: BEGIN

Line 479: From pqh_corps_definitions

475:
476: Cursor csr_corps_name
477: IS
478: Select Name
479: From pqh_corps_definitions
480: Where Corps_Definition_Id = p_corps_definition_id ;
481: l_corps_name Varchar2(240) := null;
482:
483: BEGIN

Line 630: FROM pqh_corps_definitions

626:
627: BEGIN
628: SELECT ben_pgm_id
629: INTO l_pgm_id
630: FROM pqh_corps_definitions
631: WHERE corps_definition_id = p_corps_definition_id;
632: Return l_pgm_id;
633: END;
634: