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.PER_QH_FIND_QUERY dependencies on HR_LOOKUPS

Line 43: ,nationality_meaning hr_lookups.meaning%type default null

39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null

Line 47: ,registered_disabled_flag hr_lookups.meaning%type default null

43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
49: ,sex_meaning hr_lookups.meaning%type default null
50: ,sex per_all_people_f.sex%type default null
51: ,benefit_group ben_benfts_grp.name%type default null

Line 49: ,sex_meaning hr_lookups.meaning%type default null

45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
49: ,sex_meaning hr_lookups.meaning%type default null
50: ,sex per_all_people_f.sex%type default null
51: ,benefit_group ben_benfts_grp.name%type default null
52: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
53: ,grade per_grades.name%type default null

Line 83: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null

79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%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.

Line 85: ,employment_category_meaning hr_lookups.meaning%type default null

81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%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

Line 592: ,'hr_lookups hlna_a','hlna_a.lookup_code','hlna_a.meaning',' and hlna_a.lookup_type=''NATIONALITY''');

588: elsif p_field_name='DATE_OF_BIRTH' then
589: l_a_where_clause:=build_date_where('per.date_of_birth',p_condition,p_value);
590: elsif p_field_name='NATIONALITY' then
591: l_a_where_clause:=build_varchar2_where('per.nationality',p_condition,p_value
592: ,'hr_lookups hlna_a','hlna_a.lookup_code','hlna_a.meaning',' and hlna_a.lookup_type=''NATIONALITY''');
593: elsif p_field_name='SEX' then
594: l_a_where_clause:=build_varchar2_where('per.sex',p_condition,p_value
595: ,'hr_lookups hlse_a','hlse_a.lookup_code','hlse_a.meaning',' and hlse_a.lookup_type=''SEX''');
596: elsif p_field_name='ESTABLISHMENT' then

Line 595: ,'hr_lookups hlse_a','hlse_a.lookup_code','hlse_a.meaning',' and hlse_a.lookup_type=''SEX''');

591: l_a_where_clause:=build_varchar2_where('per.nationality',p_condition,p_value
592: ,'hr_lookups hlna_a','hlna_a.lookup_code','hlna_a.meaning',' and hlna_a.lookup_type=''NATIONALITY''');
593: elsif p_field_name='SEX' then
594: l_a_where_clause:=build_varchar2_where('per.sex',p_condition,p_value
595: ,'hr_lookups hlse_a','hlse_a.lookup_code','hlse_a.meaning',' and hlse_a.lookup_type=''SEX''');
596: elsif p_field_name='ESTABLISHMENT' then
597: -- bug 3002915 starts here.
598: -- commented existing one added new.
599: --

Line 626: ,'hr_lookups hlrd_a','hlrd_a.lookup_code','hlrd_a.meaning',' and hlrd_a.lookup_type=''REGISTERED_DISABLED''');

622:
623: -- Bug 3037019 Start Here
624: elsif p_field_name='REGISTERED_DISABLED' then
625: l_a_where_clause:=build_varchar2_where('per.registered_disabled_flag',p_condition,p_value
626: ,'hr_lookups hlrd_a','hlrd_a.lookup_code','hlrd_a.meaning',' and hlrd_a.lookup_type=''REGISTERED_DISABLED''');
627: -- Bug 3037019 End Here
628:
629: elsif p_field_name='EMPLOYMENT_CATEGORY' then
630: l_a_where_clause:=build_varchar2_where('per_asg.employment_category',p_condition,p_value

Line 631: ,'hr_lookups hlec_a','hlec_a.lookup_code','hlec_a.meaning',' and hlec_a.lookup_type=''EMP_CAT''');

627: -- Bug 3037019 End Here
628:
629: elsif p_field_name='EMPLOYMENT_CATEGORY' then
630: l_a_where_clause:=build_varchar2_where('per_asg.employment_category',p_condition,p_value
631: ,'hr_lookups hlec_a','hlec_a.lookup_code','hlec_a.meaning',' and hlec_a.lookup_type=''EMP_CAT''');
632: l_asg:=TRUE;
633: elsif p_field_name='BENEFITS_GROUP' then
634: -- Bug 4060365 Changed the parameter from per.benefit_group to per.benefit_group_id and
635: -- ben_a.benefit_group_id to ben_a.benfts_grp_id

Line 759: ,'hr_lookups hlbu_a','hlbu_a.lookup_code','hlbu_a.meaning',' and hlbu_a.lookup_type=''BARGAINING_UNIT_CODE''');

755: l_asg:=TRUE;
756: elsif p_field_name='BARGAINING_UNIT' then
757: -- Bug 4060365 Changed the parameter from per.barganing_unit_code to per.bargaining_unit_code
758: l_a_where_clause:=build_varchar2_where('per_asg.bargaining_unit_code',p_condition,p_value
759: ,'hr_lookups hlbu_a','hlbu_a.lookup_code','hlbu_a.meaning',' and hlbu_a.lookup_type=''BARGAINING_UNIT_CODE''');
760: l_asg:=TRUE;
761: elsif p_field_name='COORD_BEN_MED_PLN_NO' then
762: l_a_where_clause:=build_varchar2_where('per.coord_ben_med_pln_no',p_condition,p_value);
763: elsif p_field_name='DPDNT_ADOPTION_DATE' then

Line 767: ,'hr_lookups hlcr_a','hlcr_a.lookup_code','hlcr_a.meaning',' and hlcr_a.lookup_type=''APL_ASSIGN_REASON''');

763: elsif p_field_name='DPDNT_ADOPTION_DATE' then
764: l_a_where_clause:=build_date_where('per.dpdnt_adoption_date',p_condition,p_value);
765: elsif p_field_name='CHANGE_REASON' then
766: l_a_where_clause:=build_varchar2_where('per_asg.change_reason',p_condition,p_value
767: ,'hr_lookups hlcr_a','hlcr_a.lookup_code','hlcr_a.meaning',' and hlcr_a.lookup_type=''APL_ASSIGN_REASON''');
768: l_asg:=TRUE;
769: elsif p_field_name='DATE_PROBATION_END' then
770: l_a_where_clause:=build_date_where('per_asg.date_probation_end',p_condition,p_value);
771: l_asg:=TRUE;

Line 936: l_from_clause:=l_from_clause||',hr_lookups hlnat';

932: --
933: if nationality is not null then
934: l_where_clause:=l_where_clause||' and per.nationality='''||nationality||'''';
935: elsif nationality_meaning is not null then
936: l_from_clause:=l_from_clause||',hr_lookups hlnat';
937: l_where_clause:=l_where_clause||' and per.nationality=hlnat.lookup_code'
938: ||' and hlnat.lookup_type=''NATIONALITY'''
939: ||' and upper(hlnat.meaning) like ('''||upper(replace(nationality_meaning,g_quote,g_quote||g_quote))||''')';
940: end if;

Line 951: l_from_clause:=l_from_clause||',hr_lookups hlnat';

947: l_where_clause:=l_where_clause||' and per.registered_disabled_flag='''||registered_disabled||'''';
948:
949: -- Bug 3037019 Start Here
950: elsif registered_disabled_flag is not null then
951: l_from_clause:=l_from_clause||',hr_lookups hlnat';
952: l_where_clause:=l_where_clause||' and per.registered_disabled_flag=hlnat.lookup_code'
953: ||' and hlnat.lookup_type=''REGISTERED_DISABLED'''
954: ||' and upper(hlnat.meaning) like ('''||upper(replace(registered_disabled_flag,g_quote,g_quote||g_quote))||''')';
955: -- Bug 3037019 Ends Here

Line 962: l_from_clause:=l_from_clause||',hr_lookups hlsex';

958: --
959: if sex is not null then
960: l_where_clause:=l_where_clause||' and per.sex='''||sex||'''';
961: elsif sex_meaning is not null then
962: l_from_clause:=l_from_clause||',hr_lookups hlsex';
963: l_where_clause:=l_where_clause||' and per.sex=hlsex.lookup_code'
964: ||' and hlsex.lookup_type=''SEX'''
965: ||' and upper(hlsex.meaning) like ('''||upper(replace(sex_meaning,g_quote,g_quote||g_quote))||''')';
966: end if;

Line 1247: l_from_clause:=l_from_clause||',hr_lookups buc';

1243: if bargaining_unit_code is not null then
1244: l_where_clause:=l_where_clause||' and per_asg.bargaining_unit_code='''||bargaining_unit_code||'''';
1245: l_asg:=TRUE;
1246: elsif bargaining_unit_code_meaning is not null then
1247: l_from_clause:=l_from_clause||',hr_lookups buc';
1248: l_where_clause:=l_where_clause||' and per_asg.bargaining_unit_code=buc.lookup_code'
1249: ||' and buc.lookup_type=''BARGAINING_UNIT_CODE'''
1250: ||' and upper(buc.meaning) like ('''||upper(replace(bargaining_unit_code_meaning,g_quote,g_quote||g_quote))||''')';
1251: l_asg:=TRUE;

Line 1258: l_from_clause:=l_from_clause||',hr_lookups empc';

1254: if employment_category is not null then
1255: l_where_clause:=l_where_clause||' and per_asg.employment_category='''||employment_category||'''';
1256: l_asg:=TRUE;
1257: elsif employment_category_meaning is not null then
1258: l_from_clause:=l_from_clause||',hr_lookups empc';
1259: l_where_clause:=l_where_clause||' and per_asg.employment_category=empc.lookup_code
1260: and empc.lookup_type=''EMP_CAT''
1261: and upper(empc.meaning) like ('''||upper(replace(employment_category_meaning,g_quote,g_quote||g_quote))||''')';
1262: l_asg:=TRUE;

Line 2485: ,nationality_meaning in hr_lookups.meaning%type default null

2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null

Line 2489: ,registered_disabled_flag in hr_lookups.meaning%type default null

2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2491: ,sex_meaning in hr_lookups.meaning%type default null
2492: ,sex in per_all_people_f.sex%type default null
2493: ,benefit_group in ben_benfts_grp.name%type default null

Line 2491: ,sex_meaning in hr_lookups.meaning%type default null

2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2491: ,sex_meaning in hr_lookups.meaning%type default null
2492: ,sex in per_all_people_f.sex%type default null
2493: ,benefit_group in ben_benfts_grp.name%type default null
2494: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2495: ,grade in per_grades.name%type default null

Line 2525: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null

2521: ,requisition in per_requisitions.name%type default null
2522: ,requisition_id in per_requisitions.requisition_id%type default null
2523: ,salary_basis in per_pay_bases.name%type default null
2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2525: ,bargaining_unit_code_meaning in hr_lookups.meaning%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.

Line 2527: ,employment_category_meaning in hr_lookups.meaning%type default null

2523: ,salary_basis in per_pay_bases.name%type default null
2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2525: ,bargaining_unit_code_meaning in hr_lookups.meaning%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