APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on HR_SOFT_CODING_KEYFLEX

Line 306: FROM hr_soft_coding_keyflex hsck,

302: CURSOR get_override_location(cp_assignment_id NUMBER,
303: cp_effective_date DATE)
304: IS
305: SELECT hsck.segment18
306: FROM hr_soft_coding_keyflex hsck,
307: per_all_assignments_f paf
308: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
309: AND paf.assignment_id = cp_assignment_id
310: AND cp_effective_date BETWEEN paf.effective_start_date

Line 357: ln_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
354: ln_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
355: lv_cagr_concatenated_segments VARCHAR2(2000);
356: ln_comment_id per_all_assignments_f.comment_id%TYPE;
357: ln_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
358: ld_effective_start_date DATE;
359: ld_effective_end_date DATE;
360: lv_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
361: lb_no_managers_warning BOOLEAN;

Line 360: lv_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

356: ln_comment_id per_all_assignments_f.comment_id%TYPE;
357: ln_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
358: ld_effective_start_date DATE;
359: ld_effective_end_date DATE;
360: lv_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
361: lb_no_managers_warning BOOLEAN;
362: lb_other_manager_warning BOOLEAN;
363: lb_hourly_salaried_warning BOOLEAN;
364: lb_gsp_post_process_warning VARCHAR2(2000);