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_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 920: l_from_clause:=l_from_clause||',hr_lookups hlnat';

916: --
917: if nationality is not null then
918: l_where_clause:=l_where_clause||' and per.nationality='''||nationality||'''';
919: elsif nationality_meaning is not null then
920: l_from_clause:=l_from_clause||',hr_lookups hlnat';
921: l_where_clause:=l_where_clause||' and per.nationality=hlnat.lookup_code'
922: ||' and hlnat.lookup_type=''NATIONALITY'''
923: ||' and upper(hlnat.meaning) like ('''||upper(replace(nationality_meaning,g_quote,g_quote||g_quote))||''')';
924: end if;

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

931: l_where_clause:=l_where_clause||' and per.registered_disabled_flag='''||registered_disabled||'''';
932:
933: -- Bug 3037019 Start Here
934: elsif registered_disabled_flag is not null then
935: l_from_clause:=l_from_clause||',hr_lookups hlnat';
936: l_where_clause:=l_where_clause||' and per.registered_disabled_flag=hlnat.lookup_code'
937: ||' and hlnat.lookup_type=''REGISTERED_DISABLED'''
938: ||' and upper(hlnat.meaning) like ('''||upper(replace(registered_disabled_flag,g_quote,g_quote||g_quote))||''')';
939: -- Bug 3037019 Ends Here

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

942: --
943: if sex is not null then
944: l_where_clause:=l_where_clause||' and per.sex='''||sex||'''';
945: elsif sex_meaning is not null then
946: l_from_clause:=l_from_clause||',hr_lookups hlsex';
947: l_where_clause:=l_where_clause||' and per.sex=hlsex.lookup_code'
948: ||' and hlsex.lookup_type=''SEX'''
949: ||' and upper(hlsex.meaning) like ('''||upper(replace(sex_meaning,g_quote,g_quote||g_quote))||''')';
950: end if;

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

1227: if bargaining_unit_code is not null then
1228: l_where_clause:=l_where_clause||' and per_asg.bargaining_unit_code='''||bargaining_unit_code||'''';
1229: l_asg:=TRUE;
1230: elsif bargaining_unit_code_meaning is not null then
1231: l_from_clause:=l_from_clause||',hr_lookups buc';
1232: l_where_clause:=l_where_clause||' and per_asg.bargaining_unit_code=buc.lookup_code'
1233: ||' and buc.lookup_type=''BARGAINING_UNIT_CODE'''
1234: ||' and upper(buc.meaning) like ('''||upper(replace(bargaining_unit_code_meaning,g_quote,g_quote||g_quote))||''')';
1235: l_asg:=TRUE;

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

1238: if employment_category is not null then
1239: l_where_clause:=l_where_clause||' and per_asg.employment_category='''||employment_category||'''';
1240: l_asg:=TRUE;
1241: elsif employment_category_meaning is not null then
1242: l_from_clause:=l_from_clause||',hr_lookups empc';
1243: l_where_clause:=l_where_clause||' and per_asg.employment_category=empc.lookup_code
1244: and empc.lookup_type=''EMP_CAT''
1245: and upper(empc.meaning) like ('''||upper(replace(employment_category_meaning,g_quote,g_quote||g_quote))||''')';
1246: l_asg:=TRUE;

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

2465: ,first_name in per_all_people_f.first_name%type default null
2466: ,full_name in per_all_people_f.full_name%type default null
2467: ,title in per_all_people_f.title%type
2468: ,middle_names in per_all_people_f.middle_names%type
2469: ,nationality_meaning in hr_lookups.meaning%type default null
2470: ,nationality in per_all_people_f.nationality%type default null
2471: ,national_identifier in per_all_people_f.national_identifier%type default null
2472: -- Bug 3037019 Start Here
2473: ,registered_disabled_flag in hr_lookups.meaning%type default null

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

2469: ,nationality_meaning in hr_lookups.meaning%type default null
2470: ,nationality in per_all_people_f.nationality%type default null
2471: ,national_identifier in per_all_people_f.national_identifier%type default null
2472: -- Bug 3037019 Start Here
2473: ,registered_disabled_flag in hr_lookups.meaning%type default null
2474: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2475: ,sex_meaning in hr_lookups.meaning%type default null
2476: ,sex in per_all_people_f.sex%type default null
2477: ,benefit_group in ben_benfts_grp.name%type default null

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

2471: ,national_identifier in per_all_people_f.national_identifier%type default null
2472: -- Bug 3037019 Start Here
2473: ,registered_disabled_flag in hr_lookups.meaning%type default null
2474: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2475: ,sex_meaning in hr_lookups.meaning%type default null
2476: ,sex in per_all_people_f.sex%type default null
2477: ,benefit_group in ben_benfts_grp.name%type default null
2478: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2479: ,grade in per_grades.name%type default null

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

2505: ,requisition in per_requisitions.name%type default null
2506: ,requisition_id in per_requisitions.requisition_id%type default null
2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2510: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2511: ,employment_category_meaning in hr_lookups.meaning%type default null
2512: ,employment_category in per_all_assignments_f.employment_category%type default null
2513: --bug 3002915 starts here. modified the type.

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

2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2510: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2511: ,employment_category_meaning in hr_lookups.meaning%type default null
2512: ,employment_category in per_all_assignments_f.employment_category%type default null
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