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.

[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on HR_LEG_ESTABLISHMENTS_V

Line 88: ,establishment hr_leg_establishments_v.name%type default null

84: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
85: ,employment_category_meaning hr_lookups.meaning%type default null
86: ,employment_category per_all_assignments_f.employment_category%type default null
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

Line 89: ,establishment_id hr_leg_establishments_v.organization_id%type default null

85: ,employment_category_meaning hr_lookups.meaning%type default null
86: ,employment_category per_all_assignments_f.employment_category%type default null
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

Line 605: 'hr_leg_establishments_v hle','hle.organization_id','hle.name');

601: --,'per_establishment_attendances peat_a, per_establishments pest_a ','peat_a.person_id','pest_a.name'
602: --,'pest_a.establishment_id=peat_a.establishment_id');
603: --
604: l_a_where_clause:=build_varchar2_where('per_asg.establishment_id',p_condition,p_value,
605: 'hr_leg_establishments_v hle','hle.organization_id','hle.name');
606: l_asg:=TRUE;
607: -- bug 3002915 ends here.
608: elsif p_field_name='USER_PERSON_TYPE' then
609: l_a_where_clause:=build_varchar2_where

Line 1281: ||' from hr_leg_establishments_v hle'

1277: -- bug 3002915 ends here.
1278: elsif establishment is not null then
1279: l_where_clause:=l_where_clause||' and exists'
1280: ||' (select 1'
1281: ||' from hr_leg_establishments_v hle'
1282: ||' where hle.organization_id = per_asg.establishment_id and upper(hle.name) like('''||upper(establishment)||'''))';
1283:
1284: l_asg:=TRUE;
1285: --bug 3002915.

Line 2530: ,establishment in hr_leg_establishments_v.name%type default null

2526: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2527: ,employment_category_meaning in hr_lookups.meaning%type default null
2528: ,employment_category in per_all_assignments_f.employment_category%type default null
2529: --bug 3002915 starts here. modified the type.
2530: ,establishment in hr_leg_establishments_v.name%type default null
2531: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
2532: --bug 3002915 ends here.
2533: ,projected_hire_date in per_applications.projected_hire_date%type default null
2534: ,secure in varchar2 default null

Line 2531: ,establishment_id in hr_leg_establishments_v.organization_id%type default null

2527: ,employment_category_meaning in hr_lookups.meaning%type default null
2528: ,employment_category in per_all_assignments_f.employment_category%type default null
2529: --bug 3002915 starts here. modified the type.
2530: ,establishment in hr_leg_establishments_v.name%type default null
2531: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
2532: --bug 3002915 ends here.
2533: ,projected_hire_date in per_applications.projected_hire_date%type default null
2534: ,secure in varchar2 default null
2535: ,field1_name in varchar2 default null