[Home] [Help]
87: -- BUG 3002915 starts here. modified type.
88: ,establishment hr_leg_establishments_v.name%type default null
89: ,establishment_id hr_leg_establishments_v.organization_id%type default null
90: -- BUG 3002915 ends here.
91: ,projected_hire_date per_applications.projected_hire_date%type default null
92: ,secure varchar2 default null
93: ,field1_name varchar2 default null
94: ,field1_condition_code varchar2 default null
95: ,field1_value varchar2 default null
204: and p_effective_date between date_start and nvl(final_process_date,p_effective_date);
205: --
206: cursor csr_app(p_person_id number,p_effective_date date) is
207: select projected_hire_date
208: from per_applications
209: where person_id=p_person_id
210: and p_effective_date between date_received and nvl(date_end,p_effective_date);
211: --
212: cursor csr_grade
686: --*** Changed pay_a.name to pay_a.payroll_name. Bug2830622
687: l_asg:=TRUE;
688: elsif p_field_name='PROJECTED_HIRE_DATE' then
689: l_a_where_clause:=build_date_where('per.person_id',p_condition,p_value
690: ,'per_applications pap_a ','pap_a.person_id','pap_a.projected_hire_date');
691: elsif p_field_name='HIRE_DATE' then
692: l_a_where_clause:=build_date_where('per.person_id',p_condition,p_value
693: ,'per_periods_of_service pds_a ','pds_a.person_id','pds_a.date_start');
694: elsif p_field_name='ASSIGNMENT_STATUS' then
1274: -- ||' and upper(est.name) like('''||upper(replace(establishment,g_quote,g_quote||g_quote))||'''))';
1275: end if;
1276: --
1277: if projected_hire_date is not null then
1278: l_from_clause:=l_from_clause||',per_applications appl';
1279: l_where_clause:=l_where_clause||' and appl.projected_hire_date=to_date('''||
1280: to_char(projected_hire_date,'DD/MM/YYYY')||''',''DD/MM/YYYY'')'
1281: ||' and per.person_id=appl.person_id';
1282: end if;
2513: --bug 3002915 starts here. modified the type.
2514: ,establishment in hr_leg_establishments_v.name%type default null
2515: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
2516: --bug 3002915 ends here.
2517: ,projected_hire_date in per_applications.projected_hire_date%type default null
2518: ,secure in varchar2 default null
2519: ,field1_name in varchar2 default null
2520: ,field1_condition_code in varchar2 default null
2521: ,field1_value in varchar2 default null