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_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ALL_PEOPLE_F

Line 85: race per_all_people_f.per_information4%type,

81: occupational_level_id hr_lookups.lookup_code%type,
82: occupational_category_id hr_lookups.lookup_code%type,
83: occupational_level hr_lookups.meaning%type,
84: occupational_category hr_lookups.meaning%type,
85: race per_all_people_f.per_information4%type,
86: sex per_all_people_f.sex%type,
87: annual_income number
88: );
89:

Line 86: sex per_all_people_f.sex%type,

82: occupational_category_id hr_lookups.lookup_code%type,
83: occupational_level hr_lookups.meaning%type,
84: occupational_category hr_lookups.meaning%type,
85: race per_all_people_f.per_information4%type,
86: sex per_all_people_f.sex%type,
87: annual_income number
88: );
89:
90: type r_averages is record

Line 701: l_race per_all_people_f.per_information4%type; -- Bug 4413678

697: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
698: l_input_value_id pay_input_values_f.input_value_id%type;
699: l_index number;
700: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
701: l_race per_all_people_f.per_information4%type; -- Bug 4413678
702:
703: begin
704:
705: hr_utility.set_location('Entering ' || l_proc, 10);

Line 775: From per_all_people_f papf

771:
772: -- Bug 4413678: Begin
773: Select per_information4
774: into l_race
775: From per_all_people_f papf
776: Where papf.person_id = l_assignment.person_id
777: and p_report_date between papf.effective_start_date and papf.effective_end_date;
778: -- Bug 4413678: End
779:

Line 1155: p_report_date in per_all_people_f.start_date%type,

1151: -- This function returns the person's legislated employment type (permanent or non-permanent)
1152: -- The employee has to work for a continuous period of 3 months in order to be seen as permanent
1153: function get_ee_employment_type_name
1154: (
1155: p_report_date in per_all_people_f.start_date%type,
1156: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type
1157: ) return varchar2 is
1158:
1159: l_ee_employment_type_name varchar2(13);

Line 1819: per_all_people_f papf

1815: hr_lookups hl2,
1816: hr_all_organization_units haou,
1817: per_assignment_extra_info paei,
1818: per_all_assignments_f paaf,
1819: per_all_people_f papf
1820: where papf.business_group_id = p_business_group_id
1821: and p_report_date between papf.effective_start_date and papf.effective_end_date
1822: and papf.current_employee_flag = 'Y'
1823: and paaf.person_id = papf.person_id

Line 2038: per_all_people_f papf

2034: hr_lookups hl2,
2035: hr_all_organization_units haou,
2036: per_assignment_extra_info paei,
2037: per_all_assignments_f paaf,
2038: per_all_people_f papf
2039: where papf.business_group_id = p_business_group_id
2040: and p_report_date between papf.effective_start_date and papf.effective_end_date
2041: and papf.current_employee_flag = 'Y'
2042: and paaf.person_id = papf.person_id

Line 2275: per_all_people_f papf

2271: hr_lookups hl2,
2272: hr_all_organization_units haou,
2273: per_assignment_extra_info paei,
2274: per_all_assignments_f paaf,
2275: per_all_people_f papf
2276: where papf.business_group_id = p_business_group_id
2277: and papf.current_employee_flag = 'Y'
2278: and p_report_date between papf.effective_start_date and papf.effective_end_date
2279: and paaf.person_id = papf.person_id

Line 2522: per_all_people_f papf

2518: hr_lookups hl2,
2519: hr_all_organization_units haou,
2520: per_assignment_extra_info paei,
2521: per_all_assignments_f paaf,
2522: per_all_people_f papf
2523: where papf.business_group_id = p_business_group_id
2524: and papf.current_employee_flag = 'Y'
2525: and p_report_date between papf.effective_start_date and papf.effective_end_date
2526: and paaf.person_id = papf.person_id

Line 2773: per_all_people_f papf

2769: hr_all_organization_units haou,
2770: per_assignment_extra_info paei,
2771: per_all_assignments_f paaf,
2772: per_periods_of_service ppos,
2773: per_all_people_f papf
2774: where papf.business_group_id = p_business_group_id
2775: and papf.current_employee_flag = 'Y'
2776: and ppos.person_id = papf.person_id
2777: and ppos.date_start between add_months(p_report_date, -12) + 1 and p_report_date

Line 3003: per_all_people_f papf

2999: hr_all_organization_units haou,
3000: per_assignment_extra_info paei,
3001: per_all_assignments_f paaf,
3002: per_periods_of_service ppos,
3003: per_all_people_f papf
3004: where papf.business_group_id = p_business_group_id
3005: and papf.current_employee_flag = 'Y'
3006: and ppos.person_id = papf.person_id
3007: and nvl(ppos.actual_termination_date, to_date('31-12-4712', 'DD-MM-YYYY')) > add_months(p_report_date, -12) + 1

Line 3258: per_all_people_f papf

3254: hr_all_organization_units haou,
3255: per_assignment_extra_info paei,
3256: per_all_assignments_f paaf,
3257: per_periods_of_service ppos,
3258: per_all_people_f papf
3259: where papf.business_group_id = p_business_group_id
3260: and papf.current_employee_flag = 'Y'
3261: and ppos.person_id = papf.person_id
3262: and nvl(ppos.actual_termination_date, to_date('31-12-4712', 'DD-MM-YYYY')) between add_months(p_report_date, -12) + 1 and p_report_date

Line 3524: per_all_people_f papf

3520: hr_all_organization_units haou,
3521: per_assignment_extra_info paei,
3522: per_all_assignments_f paaf,
3523: per_periods_of_service ppos,
3524: per_all_people_f papf
3525: where papf.business_group_id = p_business_group_id
3526: and papf.current_employee_flag = 'Y'
3527: and ppos.person_id = papf.person_id
3528: and nvl(ppos.actual_termination_date, to_date('31-12-4712', 'DD-MM-YYYY')) between add_months(p_report_date, -12) + 1 and p_report_date

Line 4206: , p_race IN per_all_people_f.per_information4%type

4202:
4203: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
4204: , p_occupational_level IN hr_lookups.meaning%type
4205: , p_occupational_category IN hr_lookups.meaning%type
4206: , p_race IN per_all_people_f.per_information4%type
4207: , p_sex IN per_all_people_f.sex%type
4208: , p_income IN number
4209: , p_occupational_level_id IN hr_lookups.lookup_code%type
4210: , p_occupational_category_id IN hr_lookups.lookup_code%type

Line 4207: , p_sex IN per_all_people_f.sex%type

4203: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
4204: , p_occupational_level IN hr_lookups.meaning%type
4205: , p_occupational_category IN hr_lookups.meaning%type
4206: , p_race IN per_all_people_f.per_information4%type
4207: , p_sex IN per_all_people_f.sex%type
4208: , p_income IN number
4209: , p_occupational_level_id IN hr_lookups.lookup_code%type
4210: , p_occupational_category_id IN hr_lookups.lookup_code%type
4211: ) is

Line 4571: l_race per_all_people_f.per_information4%type; -- Bug 4413678

4567: l_eea_balance_type_id pay_balance_types.balance_type_id%type;
4568: l_input_value_id pay_input_values_f.input_value_id%type;
4569: l_index number;
4570: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
4571: l_race per_all_people_f.per_information4%type; -- Bug 4413678
4572: l_sex per_all_people_f.sex%type;
4573: --Changes for Bug 7237663
4574: l_er_income number;
4575: l_er_annual_income number;

Line 4572: l_sex per_all_people_f.sex%type;

4568: l_input_value_id pay_input_values_f.input_value_id%type;
4569: l_index number;
4570: l_proc constant varchar2(60) := g_package || 'get_avg_5_lowest_salary';
4571: l_race per_all_people_f.per_information4%type; -- Bug 4413678
4572: l_sex per_all_people_f.sex%type;
4573: --Changes for Bug 7237663
4574: l_er_income number;
4575: l_er_annual_income number;
4576: l_er_balance_type_id pay_balance_types.balance_type_id%type;

Line 4669: From per_all_people_f papf

4665:
4666: -- Bug 4413678: Begin
4667: Select per_information4, papf.sex
4668: into l_race, l_sex
4669: From per_all_people_f papf
4670: Where papf.person_id = l_assignment.person_id
4671: and p_report_date between papf.effective_start_date and papf.effective_end_date;
4672: -- Bug 4413678: End
4673: