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_ASSIGNMENTS_F

Line 78: payroll_id per_all_assignments_f.payroll_id%type,

74:
75: -- Global types
76: type r_assignments is record
77: (
78: payroll_id per_all_assignments_f.payroll_id%type,
79: legal_entity_id hr_all_organization_units.organization_id%type,
80: legal_entity hr_all_organization_units.name%type,
81: occupational_level_id hr_lookups.lookup_code%type,
82: occupational_category_id hr_lookups.lookup_code%type,

Line 139: g_grade_asg_id per_all_assignments_f.assignment_id%type;

135: g_lev_Enc_Diff_table t_E_differential;
136:
137: g_grade_name per_grades.name%type;
138: g_grade_report_date date;
139: g_grade_asg_id per_all_assignments_f.assignment_id%type;
140:
141: g_position_name per_all_positions.name%type;
142: g_pos_report_date date;
143: g_pos_asg_id per_all_assignments_f.assignment_id%type;

Line 143: g_pos_asg_id per_all_assignments_f.assignment_id%type;

139: g_grade_asg_id per_all_assignments_f.assignment_id%type;
140:
141: g_position_name per_all_positions.name%type;
142: g_pos_report_date date;
143: g_pos_asg_id per_all_assignments_f.assignment_id%type;
144:
145: g_job_name per_jobs.name%type;
146: g_job_report_date date;
147: g_job_asg_id per_all_assignments_f.assignment_id%type;

Line 147: g_job_asg_id per_all_assignments_f.assignment_id%type;

143: g_pos_asg_id per_all_assignments_f.assignment_id%type;
144:
145: g_job_name per_jobs.name%type;
146: g_job_report_date date;
147: g_job_asg_id per_all_assignments_f.assignment_id%type;
148:
149: g_lev_name hr_lookups.meaning%type;
150: g_lev_report_date date;
151: g_lev_asg_id per_all_assignments_f.assignment_id%type;

Line 151: g_lev_asg_id per_all_assignments_f.assignment_id%type;

147: g_job_asg_id per_all_assignments_f.assignment_id%type;
148:
149: g_lev_name hr_lookups.meaning%type;
150: g_lev_report_date date;
151: g_lev_asg_id per_all_assignments_f.assignment_id%type;
152:
153: g_cat_name hr_lookups.meaning%type;
154: g_cat_report_date date;
155: g_cat_asg_id per_all_assignments_f.assignment_id%type;

Line 155: g_cat_asg_id per_all_assignments_f.assignment_id%type;

151: g_lev_asg_id per_all_assignments_f.assignment_id%type;
152:
153: g_cat_name hr_lookups.meaning%type;
154: g_cat_report_date date;
155: g_cat_asg_id per_all_assignments_f.assignment_id%type;
156:
157: g_lev_flex pay_user_column_instances_f.value%type := null;
158: g_lev_segment pay_user_column_instances_f.value%type := null;
159: g_cat_flex pay_user_column_instances_f.value%type := null;

Line 427: per_all_assignments_f paaf

423: + 1
424: )
425: into l_count
426: from per_assignment_status_types past,
427: per_all_assignments_f paaf
428: where paaf.assignment_id = p_assignment_id
429: and past.assignment_status_type_id = paaf.assignment_status_type_id
430: and past.per_system_status = 'ACTIVE_ASSIGN'
431: and paaf.effective_start_date <= p_report_end

Line 445: p_business_group_id in per_all_assignments_f.business_group_id%type,

441:
442: -- This function returns the termination reason from the user tables.
443: function get_termination_reason
444: (
445: p_business_group_id in per_all_assignments_f.business_group_id%type,
446: p_report_date in per_all_assignments_f.effective_end_date%type,
447: p_reason_code in per_periods_of_service.leaving_reason%type
448: ) return varchar2 is
449:

Line 446: p_report_date in per_all_assignments_f.effective_end_date%type,

442: -- This function returns the termination reason from the user tables.
443: function get_termination_reason
444: (
445: p_business_group_id in per_all_assignments_f.business_group_id%type,
446: p_report_date in per_all_assignments_f.effective_end_date%type,
447: p_reason_code in per_periods_of_service.leaving_reason%type
448: ) return varchar2 is
449:
450: l_termination_reason pay_user_column_instances_f.value%type;

Line 530: p_report_date in per_all_assignments_f.effective_end_date%type,

526:
527: -- This function returns the average 5 highest paid employees per category or level.
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,

Line 531: p_business_group_id in per_all_assignments_f.business_group_id%type,

527: -- This function returns the average 5 highest paid employees per category or level.
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,

Line 653: p_report_date in per_all_assignments_f.effective_end_date%type,

649:
650: -- This function returns the average 5 lowest paid employees per category or level.
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,

Line 654: p_business_group_id in per_all_assignments_f.business_group_id%type,

650: -- This function returns the average 5 lowest paid employees per category or level.
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,

Line 673: per_all_assignments_f paaf

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
676: and past.assignment_status_type_id = paaf.assignment_status_type_id
677: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 686: l_old_payroll_id per_all_assignments_f.payroll_id%type := -9999;

682: and nvl(paei.aei_information6, 'N') <> 'Y'
683: order by paaf.payroll_id;
684:
685: l_avg_5_lowest_salary number;
686: l_old_payroll_id per_all_assignments_f.payroll_id%type := -9999;
687: l_rowind pls_integer;
688: l_active_days number;
689: l_ee_income number;
690: l_ee_annual_income number;

Line 1156: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type

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);
1160: l_date_start per_periods_of_service.date_start%type;

Line 1221: p_report_date in per_all_assignments_f.effective_end_date%type,

1217:
1218: -- This function returns the occupational category from the common lookups table.
1219: function get_occupational_category
1220: (
1221: p_report_date in per_all_assignments_f.effective_end_date%type,
1222: p_assignment_id in per_all_assignments_f.assignment_id%type,
1223: p_job_id in per_all_assignments_f.job_id%type,
1224: p_grade_id in per_all_assignments_f.grade_id%type,
1225: p_position_id in per_all_assignments_f.position_id%type,

Line 1222: p_assignment_id in per_all_assignments_f.assignment_id%type,

1218: -- This function returns the occupational category from the common lookups table.
1219: function get_occupational_category
1220: (
1221: p_report_date in per_all_assignments_f.effective_end_date%type,
1222: p_assignment_id in per_all_assignments_f.assignment_id%type,
1223: p_job_id in per_all_assignments_f.job_id%type,
1224: p_grade_id in per_all_assignments_f.grade_id%type,
1225: p_position_id in per_all_assignments_f.position_id%type,
1226: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 1223: p_job_id in per_all_assignments_f.job_id%type,

1219: function get_occupational_category
1220: (
1221: p_report_date in per_all_assignments_f.effective_end_date%type,
1222: p_assignment_id in per_all_assignments_f.assignment_id%type,
1223: p_job_id in per_all_assignments_f.job_id%type,
1224: p_grade_id in per_all_assignments_f.grade_id%type,
1225: p_position_id in per_all_assignments_f.position_id%type,
1226: p_business_group_id in per_all_assignments_f.business_group_id%type
1227: ) return varchar2 is

Line 1224: p_grade_id in per_all_assignments_f.grade_id%type,

1220: (
1221: p_report_date in per_all_assignments_f.effective_end_date%type,
1222: p_assignment_id in per_all_assignments_f.assignment_id%type,
1223: p_job_id in per_all_assignments_f.job_id%type,
1224: p_grade_id in per_all_assignments_f.grade_id%type,
1225: p_position_id in per_all_assignments_f.position_id%type,
1226: p_business_group_id in per_all_assignments_f.business_group_id%type
1227: ) return varchar2 is
1228:

Line 1225: p_position_id in per_all_assignments_f.position_id%type,

1221: p_report_date in per_all_assignments_f.effective_end_date%type,
1222: p_assignment_id in per_all_assignments_f.assignment_id%type,
1223: p_job_id in per_all_assignments_f.job_id%type,
1224: p_grade_id in per_all_assignments_f.grade_id%type,
1225: p_position_id in per_all_assignments_f.position_id%type,
1226: p_business_group_id in per_all_assignments_f.business_group_id%type
1227: ) return varchar2 is
1228:
1229: begin

Line 1226: p_business_group_id in per_all_assignments_f.business_group_id%type

1222: p_assignment_id in per_all_assignments_f.assignment_id%type,
1223: p_job_id in per_all_assignments_f.job_id%type,
1224: p_grade_id in per_all_assignments_f.grade_id%type,
1225: p_position_id in per_all_assignments_f.position_id%type,
1226: p_business_group_id in per_all_assignments_f.business_group_id%type
1227: ) return varchar2 is
1228:
1229: begin
1230:

Line 1268: p_report_date in per_all_assignments_f.effective_end_date%type,

1264:
1265: -- This function returns the occupational levels from the user tables.
1266: function get_occupational_level
1267: (
1268: p_report_date in per_all_assignments_f.effective_end_date%type,
1269: p_assignment_id in per_all_assignments_f.assignment_id%type,
1270: p_job_id in per_all_assignments_f.job_id%type,
1271: p_grade_id in per_all_assignments_f.grade_id%type,
1272: p_position_id in per_all_assignments_f.position_id%type,

Line 1269: p_assignment_id in per_all_assignments_f.assignment_id%type,

1265: -- This function returns the occupational levels from the user tables.
1266: function get_occupational_level
1267: (
1268: p_report_date in per_all_assignments_f.effective_end_date%type,
1269: p_assignment_id in per_all_assignments_f.assignment_id%type,
1270: p_job_id in per_all_assignments_f.job_id%type,
1271: p_grade_id in per_all_assignments_f.grade_id%type,
1272: p_position_id in per_all_assignments_f.position_id%type,
1273: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 1270: p_job_id in per_all_assignments_f.job_id%type,

1266: function get_occupational_level
1267: (
1268: p_report_date in per_all_assignments_f.effective_end_date%type,
1269: p_assignment_id in per_all_assignments_f.assignment_id%type,
1270: p_job_id in per_all_assignments_f.job_id%type,
1271: p_grade_id in per_all_assignments_f.grade_id%type,
1272: p_position_id in per_all_assignments_f.position_id%type,
1273: p_business_group_id in per_all_assignments_f.business_group_id%type
1274: ) return varchar2 is

Line 1271: p_grade_id in per_all_assignments_f.grade_id%type,

1267: (
1268: p_report_date in per_all_assignments_f.effective_end_date%type,
1269: p_assignment_id in per_all_assignments_f.assignment_id%type,
1270: p_job_id in per_all_assignments_f.job_id%type,
1271: p_grade_id in per_all_assignments_f.grade_id%type,
1272: p_position_id in per_all_assignments_f.position_id%type,
1273: p_business_group_id in per_all_assignments_f.business_group_id%type
1274: ) return varchar2 is
1275:

Line 1272: p_position_id in per_all_assignments_f.position_id%type,

1268: p_report_date in per_all_assignments_f.effective_end_date%type,
1269: p_assignment_id in per_all_assignments_f.assignment_id%type,
1270: p_job_id in per_all_assignments_f.job_id%type,
1271: p_grade_id in per_all_assignments_f.grade_id%type,
1272: p_position_id in per_all_assignments_f.position_id%type,
1273: p_business_group_id in per_all_assignments_f.business_group_id%type
1274: ) return varchar2 is
1275:
1276: begin

Line 1273: p_business_group_id in per_all_assignments_f.business_group_id%type

1269: p_assignment_id in per_all_assignments_f.assignment_id%type,
1270: p_job_id in per_all_assignments_f.job_id%type,
1271: p_grade_id in per_all_assignments_f.grade_id%type,
1272: p_position_id in per_all_assignments_f.position_id%type,
1273: p_business_group_id in per_all_assignments_f.business_group_id%type
1274: ) return varchar2 is
1275:
1276: begin
1277:

Line 1317: p_job_id in per_all_assignments_f.job_id%type,

1313: (
1314: p_type in varchar2,
1315: p_flex in varchar2,
1316: p_segment in varchar2,
1317: p_job_id in per_all_assignments_f.job_id%type,
1318: p_grade_id in per_all_assignments_f.grade_id%type,
1319: p_position_id in per_all_assignments_f.position_id%type
1320: ) return varchar2 is
1321:

Line 1318: p_grade_id in per_all_assignments_f.grade_id%type,

1314: p_type in varchar2,
1315: p_flex in varchar2,
1316: p_segment in varchar2,
1317: p_job_id in per_all_assignments_f.job_id%type,
1318: p_grade_id in per_all_assignments_f.grade_id%type,
1319: p_position_id in per_all_assignments_f.position_id%type
1320: ) return varchar2 is
1321:
1322: l_name hr_lookups.meaning%type;

Line 1319: p_position_id in per_all_assignments_f.position_id%type

1315: p_flex in varchar2,
1316: p_segment in varchar2,
1317: p_job_id in per_all_assignments_f.job_id%type,
1318: p_grade_id in per_all_assignments_f.grade_id%type,
1319: p_position_id in per_all_assignments_f.position_id%type
1320: ) return varchar2 is
1321:
1322: l_name hr_lookups.meaning%type;
1323: l_sql varchar2(32767);

Line 1450: p_job_id in per_all_assignments_f.job_id%type,

1446: (
1447: p_type in varchar2,
1448: p_flex in varchar2,
1449: p_segment in varchar2,
1450: p_job_id in per_all_assignments_f.job_id%type,
1451: p_grade_id in per_all_assignments_f.grade_id%type,
1452: p_position_id in per_all_assignments_f.position_id%type
1453: ) return varchar2 is
1454:

Line 1451: p_grade_id in per_all_assignments_f.grade_id%type,

1447: p_type in varchar2,
1448: p_flex in varchar2,
1449: p_segment in varchar2,
1450: p_job_id in per_all_assignments_f.job_id%type,
1451: p_grade_id in per_all_assignments_f.grade_id%type,
1452: p_position_id in per_all_assignments_f.position_id%type
1453: ) return varchar2 is
1454:
1455: l_sql varchar2(32767);

Line 1452: p_position_id in per_all_assignments_f.position_id%type

1448: p_flex in varchar2,
1449: p_segment in varchar2,
1450: p_job_id in per_all_assignments_f.job_id%type,
1451: p_grade_id in per_all_assignments_f.grade_id%type,
1452: p_position_id in per_all_assignments_f.position_id%type
1453: ) return varchar2 is
1454:
1455: l_sql varchar2(32767);
1456: l_indicator NUMBER;

Line 1574: p_business_group_id in per_all_assignments_f.business_group_id%type

1570: -- This procedure caches the location of the occupational category and level data.
1571: procedure cache_occupational_location
1572: (
1573: p_report_date in date,
1574: p_business_group_id in per_all_assignments_f.business_group_id%type
1575: ) is
1576:
1577: l_user_table_id pay_user_tables.user_table_id%type;
1578: l_user_column_id_flex pay_user_columns.user_column_id%type;

Line 1744: p_report_date in per_all_assignments_f.effective_end_date%type,

1740: -- This function populates an entity's sex and race and category matches.
1741: procedure populate_ee_table
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:

Line 1745: p_business_group_id in per_all_assignments_f.business_group_id%type,

1741: procedure populate_ee_table
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;

Line 1759: -- Note: The date effective select on per_all_assignments_f is ok in this case, since an assignment

1755: -- 2. Occupational Categories (including employees with disabilities)
1756: -- 3. Occupational Categories (only employees with disabilities)
1757: if p_report_code = 'EQ1' then
1758:
1759: -- Note: The date effective select on per_all_assignments_f is ok in this case, since an assignment
1760: -- record always exist at the same time as an employee record with status EMP
1761: insert into per_za_employment_equity
1762: (
1763: report_id,

Line 1818: per_all_assignments_f paaf,

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
1822: and papf.current_employee_flag = 'Y'

Line 2037: per_all_assignments_f paaf,

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
2041: and papf.current_employee_flag = 'Y'

Line 2274: per_all_assignments_f paaf,

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'
2278: and p_report_date between papf.effective_start_date and papf.effective_end_date

Line 2521: per_all_assignments_f paaf,

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'
2525: and p_report_date between papf.effective_start_date and papf.effective_end_date

Line 2771: per_all_assignments_f paaf,

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
2775: and papf.current_employee_flag = 'Y'

Line 3001: per_all_assignments_f paaf,

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
3005: and papf.current_employee_flag = 'Y'

Line 3034: from per_all_assignments_f paaf1

3030: and nvl(per_za_employment_equity_pkg.get_lookup_code(per_za_employment_equity_pkg.get_occupational_level(paaf.effective_start_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id)), '9999999999') <
3031: any
3032: (
3033: select per_za_employment_equity_pkg.get_lookup_code(per_za_employment_equity_pkg.get_occupational_level(paaf1.effective_start_date, paaf1.assignment_id, paaf1.job_id, paaf1.grade_id, paaf1.position_id, paaf.business_group_id)) lookup_code
3034: from per_all_assignments_f paaf1
3035: where paaf1.person_id = papf.person_id
3036: and paaf1.primary_flag = 'Y'
3037: and per_za_employment_equity_pkg.get_lookup_code(per_za_employment_equity_pkg.get_occupational_level(paaf1.effective_start_date, paaf1.assignment_id, paaf1.job_id, paaf1.grade_id, paaf1.position_id, paaf.business_group_id)) is not null
3038: and paaf1.effective_end_date + 1 = paaf.effective_start_date

Line 3256: per_all_assignments_f paaf,

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
3260: and papf.current_employee_flag = 'Y'

Line 3522: per_all_assignments_f paaf,

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
3526: and papf.current_employee_flag = 'Y'

Line 3745: p_report_date in per_all_assignments_f.effective_end_date%type,

3741:
3742:
3743: function get_functional_type
3744: (
3745: p_report_date in per_all_assignments_f.effective_end_date%type,
3746: p_assignment_id in per_all_assignments_f.assignment_id%type,
3747: p_job_id in per_all_assignments_f.job_id%type,
3748: p_grade_id in per_all_assignments_f.grade_id%type,
3749: p_position_id in per_all_assignments_f.position_id%type,

Line 3746: p_assignment_id in per_all_assignments_f.assignment_id%type,

3742:
3743: function get_functional_type
3744: (
3745: p_report_date in per_all_assignments_f.effective_end_date%type,
3746: p_assignment_id in per_all_assignments_f.assignment_id%type,
3747: p_job_id in per_all_assignments_f.job_id%type,
3748: p_grade_id in per_all_assignments_f.grade_id%type,
3749: p_position_id in per_all_assignments_f.position_id%type,
3750: p_business_group_id in per_all_assignments_f.business_group_id%type

Line 3747: p_job_id in per_all_assignments_f.job_id%type,

3743: function get_functional_type
3744: (
3745: p_report_date in per_all_assignments_f.effective_end_date%type,
3746: p_assignment_id in per_all_assignments_f.assignment_id%type,
3747: p_job_id in per_all_assignments_f.job_id%type,
3748: p_grade_id in per_all_assignments_f.grade_id%type,
3749: p_position_id in per_all_assignments_f.position_id%type,
3750: p_business_group_id in per_all_assignments_f.business_group_id%type
3751: ) return VARCHAR2 is

Line 3748: p_grade_id in per_all_assignments_f.grade_id%type,

3744: (
3745: p_report_date in per_all_assignments_f.effective_end_date%type,
3746: p_assignment_id in per_all_assignments_f.assignment_id%type,
3747: p_job_id in per_all_assignments_f.job_id%type,
3748: p_grade_id in per_all_assignments_f.grade_id%type,
3749: p_position_id in per_all_assignments_f.position_id%type,
3750: p_business_group_id in per_all_assignments_f.business_group_id%type
3751: ) return VARCHAR2 is
3752:

Line 3749: p_position_id in per_all_assignments_f.position_id%type,

3745: p_report_date in per_all_assignments_f.effective_end_date%type,
3746: p_assignment_id in per_all_assignments_f.assignment_id%type,
3747: p_job_id in per_all_assignments_f.job_id%type,
3748: p_grade_id in per_all_assignments_f.grade_id%type,
3749: p_position_id in per_all_assignments_f.position_id%type,
3750: p_business_group_id in per_all_assignments_f.business_group_id%type
3751: ) return VARCHAR2 is
3752:
3753: begin

Line 3750: p_business_group_id in per_all_assignments_f.business_group_id%type

3746: p_assignment_id in per_all_assignments_f.assignment_id%type,
3747: p_job_id in per_all_assignments_f.job_id%type,
3748: p_grade_id in per_all_assignments_f.grade_id%type,
3749: p_position_id in per_all_assignments_f.position_id%type,
3750: p_business_group_id in per_all_assignments_f.business_group_id%type
3751: ) return VARCHAR2 is
3752:
3753: begin
3754: -- Check whether we have cached the location of Occupational data

Line 3792: p_job_id in per_all_assignments_f.job_id%type,

3788: function get_functional_data
3789: (
3790: p_flex in varchar2,
3791: p_segment in varchar2,
3792: p_job_id in per_all_assignments_f.job_id%type,
3793: p_grade_id in per_all_assignments_f.grade_id%type,
3794: p_position_id in per_all_assignments_f.position_id%type
3795: ) return varchar2 is
3796:

Line 3793: p_grade_id in per_all_assignments_f.grade_id%type,

3789: (
3790: p_flex in varchar2,
3791: p_segment in varchar2,
3792: p_job_id in per_all_assignments_f.job_id%type,
3793: p_grade_id in per_all_assignments_f.grade_id%type,
3794: p_position_id in per_all_assignments_f.position_id%type
3795: ) return varchar2 is
3796:
3797: l_sql varchar2(32767);

Line 3794: p_position_id in per_all_assignments_f.position_id%type

3790: p_flex in varchar2,
3791: p_segment in varchar2,
3792: p_job_id in per_all_assignments_f.job_id%type,
3793: p_grade_id in per_all_assignments_f.grade_id%type,
3794: p_position_id in per_all_assignments_f.position_id%type
3795: ) return varchar2 is
3796:
3797: l_sql varchar2(32767);
3798: l_name hr_lookups.meaning%type;

Line 3889: p_report_date in per_all_assignments_f.effective_end_date%type,

3885: end get_functional_data;
3886:
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:

Line 3890: p_business_group_id in per_all_assignments_f.business_group_id%type,

3886:
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

Line 4511: p_report_date in per_all_assignments_f.effective_end_date%type,

4507: -- Procedure to initialise with the employee details
4508: --
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

Line 4512: p_business_group_id in per_all_assignments_f.business_group_id%type,

4508: --
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:

Line 4529: per_all_assignments_f paaf,

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,
4532: hr_lookups hl_fn
4533: where paaf.business_group_id = p_business_group_id

Line 4556: l_old_payroll_id per_all_assignments_f.payroll_id%type := -9999;

4552: AND hl_fn.meaning(+) = per_za_employment_equity_pkg.get_functional_type(p_report_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id)
4553: and nvl(paei.aei_information6, 'N') <> 'Y'
4554: order BY paei.aei_information7, paaf.payroll_id;
4555:
4556: l_old_payroll_id per_all_assignments_f.payroll_id%type := -9999;
4557: l_rowind pls_integer;
4558: l_active_days number;
4559: l_ee_income number;
4560: l_ee_annual_income number;