APPS.GHR_PAY_CAPS dependencies on PER_ASSIGNMENTS_F

Line 395: l_assignment_id per_assignments_f.assignment_id%type;

391: l_old_converted_total_salary NUMBER;
392: l_ra_diff NUMBER;
393: l_calc_retention_allowance NUMBER;
394:
395: l_assignment_id per_assignments_f.assignment_id%type;
396: l_to_auo_premium_pay_indicator VARCHAR2(30);
397: l_to_ap_premium_pay_indicator VARCHAR2(30);
398: l_multi_error_flag BOOLEAN;
399: l_adj_basic_message BOOLEAN := FALSE;

Line 425: from per_assignments_f asg

421: -- Bug 5482191 End
422:
423: cursor c_assignment_by_per_id (per_id number, eff_date date) is
424: select asg.assignment_id
425: from per_assignments_f asg
426: where asg.person_id = per_id
427: and trunc(eff_date) between asg.effective_start_date
428: and asg.effective_end_date
429: and asg.primary_flag = 'Y';