DBA Data[Home] [Help]

APPS.HXT_TD_UTIL dependencies on PER_ASSIGNMENTS_F

Line 1455: per_assignments_f asg

1451: IS
1452: SELECT pro.proposed_salary, ppb.pay_basis
1453: FROM per_pay_proposals pro,
1454: per_pay_bases ppb,
1455: per_assignments_f asg
1456: WHERE pro.assignment_id = p_assignment_id
1457: AND ppb.pay_basis_id = asg.pay_basis_id
1458: AND asg.assignment_id = pro.assignment_id
1459: AND p_eff_date BETWEEN asg.effective_start_date