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_ASSIGNMENT_EXTRA_INFO

Line 532: p_legent_param in per_assignment_extra_info.aei_information7%type := null,

528: function get_avg_5_highest_salary
529: (
530: p_report_date in per_all_assignments_f.effective_end_date%type,
531: p_business_group_id in per_all_assignments_f.business_group_id%type,
532: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
533: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
534: p_occupational_level_cat in hr_lookups.meaning%type,
535: p_lookup_code in hr_lookups.lookup_code%type,
536: p_occupational_type in varchar2, -- CAT = Category, LEV = Level

Line 533: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

529: (
530: p_report_date in per_all_assignments_f.effective_end_date%type,
531: p_business_group_id in per_all_assignments_f.business_group_id%type,
532: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
533: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
534: p_occupational_level_cat in hr_lookups.meaning%type,
535: p_lookup_code in hr_lookups.lookup_code%type,
536: p_occupational_type in varchar2, -- CAT = Category, LEV = Level
537: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method

Line 655: p_legent_param in per_assignment_extra_info.aei_information7%type := null,

651: function get_avg_5_lowest_salary
652: (
653: p_report_date in per_all_assignments_f.effective_end_date%type,
654: p_business_group_id in per_all_assignments_f.business_group_id%type,
655: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
656: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
657: p_occupational_level_cat in hr_lookups.meaning%type,
658: p_lookup_code in hr_lookups.lookup_code%type,
659: p_occupational_type in varchar2, -- LEV = Levels, CAT = Categories

Line 656: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

652: (
653: p_report_date in per_all_assignments_f.effective_end_date%type,
654: p_business_group_id in per_all_assignments_f.business_group_id%type,
655: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
656: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
657: p_occupational_level_cat in hr_lookups.meaning%type,
658: p_lookup_code in hr_lookups.lookup_code%type,
659: p_occupational_type in varchar2, -- LEV = Levels, CAT = Categories
660: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method

Line 671: from per_assignment_extra_info paei,

667: paei.aei_information7,
668: per_za_employment_equity_pkg.get_occupational_level(p_report_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id) occupational_level,
669: per_za_employment_equity_pkg.get_occupational_category(p_report_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id) occupational_category,
670: paaf.pay_basis_id
671: from per_assignment_extra_info paei,
672: per_assignment_status_types past,
673: per_all_assignments_f paaf
674: where paaf.business_group_id = p_business_group_id
675: and p_report_date between paaf.effective_start_date and paaf.effective_end_date

Line 1746: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null

1742: (
1743: p_report_code in varchar2,
1744: p_report_date in per_all_assignments_f.effective_end_date%type,
1745: p_business_group_id in per_all_assignments_f.business_group_id%type,
1746: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
1747: ) is
1748:
1749: l_counter number;
1750: l_reason varchar2(200);

Line 1817: per_assignment_extra_info paei,

1813: from hr_lookups hl,
1814: hr_lookups hl1,
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

Line 2036: per_assignment_extra_info paei,

2032: from hr_lookups hl,
2033: hr_lookups hl1,
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

Line 2273: per_assignment_extra_info paei,

2269: from hr_lookups hl,
2270: hr_lookups hl1,
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'

Line 2520: per_assignment_extra_info paei,

2516: from hr_lookups hl,
2517: hr_lookups hl1,
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'

Line 2770: per_assignment_extra_info paei,

2766: from hr_lookups hl,
2767: hr_lookups hl1,
2768: hr_lookups hl2,
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

Line 3000: per_assignment_extra_info paei,

2996: from hr_lookups hl,
2997: hr_lookups hl1,
2998: hr_lookups hl2,
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

Line 3255: per_assignment_extra_info paei,

3251: from hr_lookups hl,
3252: hr_lookups hl1,
3253: hr_lookups hl2,
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

Line 3521: per_assignment_extra_info paei,

3517: from hr_lookups hl,
3518: hr_lookups hl1,
3519: hr_lookups hl2,
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

Line 3891: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null

3887: procedure populate_ee_table_EEWF
3888: (
3889: p_report_date in per_all_assignments_f.effective_end_date%type,
3890: p_business_group_id in per_all_assignments_f.business_group_id%type,
3891: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
3892: ) is
3893:
3894: begin
3895: DELETE FROM per_za_employment_equity

Line 4513: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

4509: procedure init_g_cat_lev_table
4510: (
4511: p_report_date in per_all_assignments_f.effective_end_date%type,
4512: p_business_group_id in per_all_assignments_f.business_group_id%type,
4513: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
4514: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
4515: ) is
4516:
4517: cursor c_assignments is

Line 4527: from per_assignment_extra_info paei,

4523: hl_lev.lookup_code OCCUPATIONAL_LEVEL_ID,
4524: per_za_employment_equity_pkg.get_occupational_level(p_report_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id) occupational_level,
4525: per_za_employment_equity_pkg.get_occupational_category(p_report_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id) occupational_category,
4526: paaf.pay_basis_id
4527: from per_assignment_extra_info paei,
4528: per_assignment_status_types past,
4529: per_all_assignments_f paaf,
4530: hr_lookups hl_cat,
4531: hr_lookups hl_lev,