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 579: p_legent_param in per_assignment_extra_info.aei_information7%type := null,

575: function get_avg_5_highest_salary
576: (
577: p_report_date in per_all_assignments_f.effective_end_date%type,
578: p_business_group_id in per_all_assignments_f.business_group_id%type,
579: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
580: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
581: p_occupational_level_cat in hr_lookups.meaning%type,
582: p_lookup_code in hr_lookups.lookup_code%type,
583: p_occupational_type in varchar2, -- CAT = Category, LEV = Level

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

576: (
577: p_report_date in per_all_assignments_f.effective_end_date%type,
578: p_business_group_id in per_all_assignments_f.business_group_id%type,
579: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
580: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
581: p_occupational_level_cat in hr_lookups.meaning%type,
582: p_lookup_code in hr_lookups.lookup_code%type,
583: p_occupational_type in varchar2, -- CAT = Category, LEV = Level
584: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method

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

698: function get_avg_5_lowest_salary
699: (
700: p_report_date in per_all_assignments_f.effective_end_date%type,
701: p_business_group_id in per_all_assignments_f.business_group_id%type,
702: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
703: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
704: p_occupational_level_cat in hr_lookups.meaning%type,
705: p_lookup_code in hr_lookups.lookup_code%type,
706: p_occupational_type in varchar2, -- LEV = Levels, CAT = Categories

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

699: (
700: p_report_date in per_all_assignments_f.effective_end_date%type,
701: p_business_group_id in per_all_assignments_f.business_group_id%type,
702: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
703: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
704: p_occupational_level_cat in hr_lookups.meaning%type,
705: p_lookup_code in hr_lookups.lookup_code%type,
706: p_occupational_type in varchar2, -- LEV = Levels, CAT = Categories
707: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method

Line 718: from per_assignment_extra_info paei,

714: paei.aei_information7,
715: 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,
716: 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,
717: paaf.pay_basis_id
718: from per_assignment_extra_info paei,
719: per_assignment_status_types past,
720: per_all_assignments_f paaf
721: where paaf.business_group_id = p_business_group_id
722: and p_report_date between paaf.effective_start_date and paaf.effective_end_date

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

1800: (
1801: p_report_code in varchar2,
1802: p_report_date in per_all_assignments_f.effective_end_date%type,
1803: p_business_group_id in per_all_assignments_f.business_group_id%type,
1804: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
1805: ) is
1806:
1807: l_counter number;
1808: l_reason varchar2(200);

Line 1875: per_assignment_extra_info paei,

1871: from hr_lookups hl,
1872: hr_lookups hl1,
1873: hr_lookups hl2,
1874: hr_all_organization_units haou,
1875: per_assignment_extra_info paei,
1876: per_all_assignments_f paaf,
1877: per_all_people_f papf
1878: where papf.business_group_id = p_business_group_id
1879: and p_report_date between papf.effective_start_date and papf.effective_end_date

Line 2094: per_assignment_extra_info paei,

2090: from hr_lookups hl,
2091: hr_lookups hl1,
2092: hr_lookups hl2,
2093: hr_all_organization_units haou,
2094: per_assignment_extra_info paei,
2095: per_all_assignments_f paaf,
2096: per_all_people_f papf
2097: where papf.business_group_id = p_business_group_id
2098: and p_report_date between papf.effective_start_date and papf.effective_end_date

Line 2331: per_assignment_extra_info paei,

2327: from hr_lookups hl,
2328: hr_lookups hl1,
2329: hr_lookups hl2,
2330: hr_all_organization_units haou,
2331: per_assignment_extra_info paei,
2332: per_all_assignments_f paaf,
2333: per_all_people_f papf
2334: where papf.business_group_id = p_business_group_id
2335: and papf.current_employee_flag = 'Y'

Line 2578: per_assignment_extra_info paei,

2574: from hr_lookups hl,
2575: hr_lookups hl1,
2576: hr_lookups hl2,
2577: hr_all_organization_units haou,
2578: per_assignment_extra_info paei,
2579: per_all_assignments_f paaf,
2580: per_all_people_f papf
2581: where papf.business_group_id = p_business_group_id
2582: and papf.current_employee_flag = 'Y'

Line 2828: per_assignment_extra_info paei,

2824: from hr_lookups hl,
2825: hr_lookups hl1,
2826: hr_lookups hl2,
2827: hr_all_organization_units haou,
2828: per_assignment_extra_info paei,
2829: per_all_assignments_f paaf,
2830: per_periods_of_service ppos,
2831: per_all_people_f papf
2832: where papf.business_group_id = p_business_group_id

Line 3058: per_assignment_extra_info paei,

3054: from hr_lookups hl,
3055: hr_lookups hl1,
3056: hr_lookups hl2,
3057: hr_all_organization_units haou,
3058: per_assignment_extra_info paei,
3059: per_all_assignments_f paaf,
3060: per_periods_of_service ppos,
3061: per_all_people_f papf
3062: where papf.business_group_id = p_business_group_id

Line 3313: per_assignment_extra_info paei,

3309: from hr_lookups hl,
3310: hr_lookups hl1,
3311: hr_lookups hl2,
3312: hr_all_organization_units haou,
3313: per_assignment_extra_info paei,
3314: per_all_assignments_f paaf,
3315: per_periods_of_service ppos,
3316: per_all_people_f papf
3317: where papf.business_group_id = p_business_group_id

Line 3579: per_assignment_extra_info paei,

3575: from hr_lookups hl,
3576: hr_lookups hl1,
3577: hr_lookups hl2,
3578: hr_all_organization_units haou,
3579: per_assignment_extra_info paei,
3580: per_all_assignments_f paaf,
3581: per_periods_of_service ppos,
3582: per_all_people_f papf
3583: where papf.business_group_id = p_business_group_id

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

3946: procedure populate_ee_table_EEWF
3947: (
3948: p_report_date in per_all_assignments_f.effective_end_date%type,
3949: p_business_group_id in per_all_assignments_f.business_group_id%type,
3950: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
3951: ) is
3952:
3953: begin
3954: DELETE FROM per_za_employment_equity

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

4571: procedure init_g_cat_lev_table
4572: (
4573: p_report_date in per_all_assignments_f.effective_end_date%type,
4574: p_business_group_id in per_all_assignments_f.business_group_id%type,
4575: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
4576: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
4577: ) is
4578: /* commented for Bug 8911880
4579: cursor c_assignments is

Line 4589: from per_assignment_extra_info paei,

4585: hl_lev.lookup_code OCCUPATIONAL_LEVEL_ID,
4586: 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,
4587: 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,
4588: paaf.pay_basis_id
4589: from per_assignment_extra_info paei,
4590: per_assignment_status_types past,
4591: per_all_assignments_f paaf,
4592: hr_lookups hl_cat,
4593: hr_lookups hl_lev,

Line 4629: from per_assignment_extra_info paei,

4625: hl_lev.lookup_code OCCUPATIONAL_LEVEL_ID,
4626: 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,
4627: 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,
4628: paaf.pay_basis_id
4629: from per_assignment_extra_info paei,
4630: per_all_assignments_f paaf,
4631: hr_lookups hl_cat,
4632: hr_lookups hl_lev,
4633: hr_lookups hl_fn

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

5968: procedure init_g_cat_lev_new_table
5969: (
5970: p_report_date in per_all_assignments_f.effective_end_date%type,
5971: p_business_group_id in per_all_assignments_f.business_group_id%type,
5972: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
5973: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
5974: ) is
5975: /* commented for Bug 8911880
5976: cursor c_assignments is

Line 5986: from per_assignment_extra_info paei,

5982: hl_lev.lookup_code OCCUPATIONAL_LEVEL_ID,
5983: 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,
5984: 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,
5985: paaf.pay_basis_id
5986: from per_assignment_extra_info paei,
5987: per_assignment_status_types past,
5988: per_all_assignments_f paaf,
5989: hr_lookups hl_cat,
5990: hr_lookups hl_lev,

Line 6026: from per_assignment_extra_info paei,

6022: hl_lev.lookup_code OCCUPATIONAL_LEVEL_ID,
6023: 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,2009) occupational_level,
6024: nvl(decode(paei.aei_information11,'P','Permanent','N','Non-Permanent'), per_za_employment_equity_pkg.get_ee_employment_type_name(p_report_date, paaf.period_of_service_id)) employment_type,
6025: paaf.pay_basis_id
6026: from per_assignment_extra_info paei,
6027: per_all_assignments_f paaf,
6028: hr_lookups hl_lev,
6029: hr_lookups hl_fn
6030: where paaf.business_group_id = p_business_group_id

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

7384: (
7385: p_report_code in varchar2,
7386: p_report_date in per_all_assignments_f.effective_end_date%type,
7387: p_business_group_id in per_all_assignments_f.business_group_id%type,
7388: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
7389: ) is
7390:
7391: l_counter number;
7392: l_reason varchar2(200);

Line 7462: per_assignment_extra_info paei,

7458: from hr_lookups hl,
7459: hr_lookups hl1,
7460: hr_lookups hl2,
7461: hr_all_organization_units haou,
7462: per_assignment_extra_info paei,
7463: per_all_assignments_f paaf,
7464: per_all_people_f papf
7465: where papf.business_group_id = p_business_group_id
7466: and p_report_date between papf.effective_start_date and papf.effective_end_date

Line 7681: per_assignment_extra_info paei,

7677: from hr_lookups hl,
7678: hr_lookups hl1,
7679: -- hr_lookups hl2,
7680: hr_all_organization_units haou,
7681: per_assignment_extra_info paei,
7682: per_all_assignments_f paaf,
7683: per_all_people_f papf
7684: where papf.business_group_id = p_business_group_id
7685: and p_report_date between papf.effective_start_date and papf.effective_end_date

Line 7918: per_assignment_extra_info paei,

7914: from hr_lookups hl,
7915: hr_lookups hl1,
7916: -- hr_lookups hl2,
7917: hr_all_organization_units haou,
7918: per_assignment_extra_info paei,
7919: per_all_assignments_f paaf,
7920: per_all_people_f papf
7921: where papf.business_group_id = p_business_group_id
7922: and papf.current_employee_flag = 'Y'

Line 8165: per_assignment_extra_info paei,

8161: from hr_lookups hl,
8162: hr_lookups hl1,
8163: -- hr_lookups hl2,
8164: hr_all_organization_units haou,
8165: per_assignment_extra_info paei,
8166: per_all_assignments_f paaf,
8167: per_all_people_f papf
8168: where papf.business_group_id = p_business_group_id
8169: and papf.current_employee_flag = 'Y'

Line 8415: per_assignment_extra_info paei,

8411: from hr_lookups hl,
8412: hr_lookups hl1,
8413: -- hr_lookups hl2,
8414: hr_all_organization_units haou,
8415: per_assignment_extra_info paei,
8416: per_all_assignments_f paaf,
8417: per_periods_of_service ppos,
8418: per_all_people_f papf
8419: where papf.business_group_id = p_business_group_id

Line 8645: per_assignment_extra_info paei,

8641: from hr_lookups hl,
8642: hr_lookups hl1,
8643: -- hr_lookups hl2,
8644: hr_all_organization_units haou,
8645: per_assignment_extra_info paei,
8646: per_all_assignments_f paaf,
8647: per_periods_of_service ppos,
8648: per_all_people_f papf
8649: where papf.business_group_id = p_business_group_id

Line 8900: per_assignment_extra_info paei,

8896: from hr_lookups hl,
8897: hr_lookups hl1,
8898: -- hr_lookups hl2,
8899: hr_all_organization_units haou,
8900: per_assignment_extra_info paei,
8901: per_all_assignments_f paaf,
8902: per_periods_of_service ppos,
8903: per_all_people_f papf
8904: where papf.business_group_id = p_business_group_id

Line 9169: per_assignment_extra_info paei,

9165: from hr_lookups hl,
9166: hr_lookups hl1,
9167: -- hr_lookups hl2,
9168: hr_all_organization_units haou,
9169: per_assignment_extra_info paei,
9170: per_all_assignments_f paaf,
9171: per_periods_of_service ppos,
9172: per_all_people_f papf
9173: where papf.business_group_id = p_business_group_id

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

9409: procedure populate_ee_table_EEWF_new
9410: (
9411: p_report_date in per_all_assignments_f.effective_end_date%type,
9412: p_business_group_id in per_all_assignments_f.business_group_id%type,
9413: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
9414: ) is
9415:
9416: begin
9417: DELETE FROM per_za_employment_equity