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_LOS_BUS dependencies on PQH_SITUATIONS

Line 30: , pqh_situations los

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_situations los
31: where los.situation_id = p_situation_id
32: and pbg.business_group_id = los.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_situations los

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_situations los
95: where los.situation_id = p_situation_id
96: and pbg.business_group_id = los.business_group_id;
97: --
98: -- Declare local variables

Line 569: select situation_id from pqh_situations where

565: p_length_of_service in varchar2,p_employee_type in varchar2,p_situation_id in number default NULL ) IS
566: -- Variable to check for duplicate.
567: l_situation_id NUMBER(15,0);
568: CURSOR cur_duplicate is
569: select situation_id from pqh_situations where
570: rownum < 2
571: AND situation_id <> decode(p_situation_id,null,-1,p_situation_id)
572: AND SITUATION = p_situation
573: AND SITUATION_TYPE = p_situation_type