APPS.GHR_PAY_CAPS dependencies on PER_ASSIGNMENTS_F

Line 412: l_assignment_id per_assignments_f.assignment_id%type;

408: l_old_converted_total_salary NUMBER;
409: l_ra_diff NUMBER;
410: l_calc_retention_allowance NUMBER;
411:
412: l_assignment_id per_assignments_f.assignment_id%type;
413: l_to_auo_premium_pay_indicator VARCHAR2(30);
414: l_to_ap_premium_pay_indicator VARCHAR2(30);
415: l_multi_error_flag BOOLEAN;
416: l_adj_basic_message BOOLEAN := FALSE;

Line 443: from per_assignments_f asg

439: -- Bug 5482191 End
440:
441: cursor c_assignment_by_per_id (per_id number, eff_date date) is
442: select asg.assignment_id
443: from per_assignments_f asg
444: where asg.person_id = per_id
445: and trunc(eff_date) between asg.effective_start_date
446: and asg.effective_end_date
447: and asg.primary_flag = 'Y';