APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 426: from per_assignment_status_types past,

422: decode(sign(p_report_start - paaf.effective_start_date), 1, p_report_start, paaf.effective_start_date)
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'

Line 672: per_assignment_status_types past,

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

Line 4528: per_assignment_status_types past,

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