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 3658: from dual

3654: and psf.effective_start_date between
3655: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3656: union
3657: select p_start_date effective_date
3658: from dual
3659: union
3660: select nvl(p_end_date, hr_general.end_of_time) effective_date
3661: from dual;
3662: --

Line 3661: from dual;

3657: select p_start_date effective_date
3658: from dual
3659: union
3660: select nvl(p_end_date, hr_general.end_of_time) effective_date
3661: from dual;
3662: --
3663: cursor c2(p_position_id number) is
3664: select business_group_id
3665: from hr_all_positions_f

Line 4714: from dual

4710: --
4711: cursor c_appr_sal_prop_exist(p_assignment_id number,
4712: p_effective_date date) is
4713: select 'x'
4714: from dual
4715: where exists (
4716: select null
4717: from per_pay_proposals
4718: where assignment_id = p_assignment_id