APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 473: from per_assignment_status_types past,

469: decode(sign(p_report_start - paaf.effective_start_date), 1, p_report_start, paaf.effective_start_date)
470: + 1
471: )
472: into l_count
473: from per_assignment_status_types past,
474: per_all_assignments_f paaf
475: where paaf.assignment_id = p_assignment_id
476: and past.assignment_status_type_id = paaf.assignment_status_type_id
477: and past.per_system_status = 'ACTIVE_ASSIGN'

Line 719: per_assignment_status_types past,

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
723: and past.assignment_status_type_id = paaf.assignment_status_type_id

Line 4590: per_assignment_status_types past,

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,
4594: hr_lookups hl_fn

Line 4638: per_assignment_status_types past

4634: where paaf.business_group_id = p_business_group_id
4635: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)
4636: and paaf.effective_end_date = ( select max(paaf1.effective_end_date)
4637: from per_all_assignments_f paaf1,
4638: per_assignment_status_types past
4639: where paaf1.assignment_id = paaf.assignment_id
4640: and paaf1.effective_start_date <= p_report_date
4641: and past.assignment_status_type_id = paaf1.assignment_status_type_id
4642: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 5987: per_assignment_status_types past,

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,
5991: hr_lookups hl_fn

Line 6034: per_assignment_status_types past

6030: where paaf.business_group_id = p_business_group_id
6031: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)
6032: and paaf.effective_end_date = ( select max(paaf1.effective_end_date)
6033: from per_all_assignments_f paaf1,
6034: per_assignment_status_types past
6035: where paaf1.assignment_id = paaf.assignment_id
6036: and paaf1.effective_start_date <= p_report_date
6037: and past.assignment_status_type_id = paaf1.assignment_status_type_id
6038: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')