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_PSF_BUS dependencies on DUAL

Line 28: from dual

24: l_proc varchar2(100):= 'PQH_PSF_BUS.POS_ASSIGNMENTS_EXIST';
25:
26: cursor c1 is
27: select 'x'
28: from dual
29: where exists (
30: select null
31: from per_all_assignments_f asg, per_assignment_status_types ast
32: where asg.position_id = p_position_id

Line 138: from dual

134: and ((a.effective_end_date between p_validation_start_date and p_validation_end_date)
135: ))
136: union
137: select p_validation_start_date ed
138: from dual
139: union
140: select p_validation_end_date ed
141: from dual);
142: --

Line 141: from dual);

137: select p_validation_start_date ed
138: from dual
139: union
140: select p_validation_end_date ed
141: from dual);
142: --
143: begin
144: --
145: /*

Line 3390: from dual

3386: and psf.effective_start_date between
3387: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3388: union
3389: select p_start_date effective_date
3390: from dual
3391: union
3392: select nvl(p_end_date, hr_general.end_of_time) effective_date
3393: from dual;
3394: --

Line 3393: from dual;

3389: select p_start_date effective_date
3390: from dual
3391: union
3392: select nvl(p_end_date, hr_general.end_of_time) effective_date
3393: from dual;
3394: --
3395: cursor c2(p_position_id number) is
3396: select business_group_id
3397: from hr_all_positions_f

Line 4326: from dual

4322: --
4323: cursor c_appr_sal_prop_exist(p_assignment_id number,
4324: p_effective_date date) is
4325: select 'x'
4326: from dual
4327: where exists (
4328: select null
4329: from per_pay_proposals
4330: where assignment_id = p_assignment_id