APPS.HR_BIS_ALERTS dependencies on PER_JOB_EXTRA_INFO

Line 2141: FROM per_job_extra_info jei

2137: FROM per_all_assignments_f asg
2138: , per_assignment_status_types ast
2139: WHERE ( (p_c_actual_rec.dim2_level_value_name = 'JOB CATEGORY'
2140: AND asg.job_id IN (SELECT jei.job_id
2141: FROM per_job_extra_info jei
2142: WHERE jei.jei_information1 = p_c_actual_rec.dim2_level_value_id)
2143: )
2144: OR
2145: (p_c_actual_rec.dim2_level_value_name = 'JOB'

Line 2282: FROM per_job_extra_info jei

2278: AND tp.time_period_id = bval.time_period_id
2279: AND be.organization_id = p_target_rec.org_level_value_id
2280: AND ((p_target_rec.dim2_level_short_name = 'JOB CATEGORY'
2281: AND be.job_id IN (SELECT jei.job_id
2282: FROM per_job_extra_info jei
2283: WHERE jei.jei_information1 = p_target_rec.dim2_level_value_id))
2284: OR (p_target_rec.dim2_level_short_name = 'JOB'
2285: AND be.job_id = p_target_rec.dim2_level_value_id)
2286: OR (p_target_rec.dim2_level_short_name = 'TOTAL JOBS'))

Line 2646: FROM per_job_extra_info jei

2642: FROM per_vacancies v
2643: WHERE ( (p_c_actual_rec.dim2_level_value_name = 'JOB CATEGORY'
2644: AND v.job_id IN
2645: (SELECT jei.job_id
2646: FROM per_job_extra_info jei
2647: WHERE jei.jei_information1
2648: = p_c_actual_rec.dim2_level_value_id)
2649: )
2650: OR

Line 3189: FROM per_job_extra_info jei

3185: /* Dim 2 Job or Job Category*/
3186: AND ( (p_c_actual_rec.dim2_level_value_name = 'TOTAL JOBS')
3187: OR (p_c_actual_rec.dim2_level_value_name = 'JOB CATEGORY'
3188: AND asg.job_id IN (SELECT jei.job_id
3189: FROM per_job_extra_info jei
3190: WHERE jei.jei_information1 = p_c_actual_rec.dim2_level_value_id))
3191: OR (p_c_actual_rec.dim2_level_value_name = 'JOB'
3192: AND asg.job_id = p_c_actual_rec.dim2_level_value_id)
3193: )