DBA Data[Home] [Help]

APPS.HXT_TD_UTIL dependencies on PER_ASSIGNMENTS_F

Line 669: per_assignments_f asg

665: IS
666: SELECT pro.proposed_salary, ppb.pay_basis
667: FROM per_pay_proposals pro,
668: per_pay_bases ppb,
669: per_assignments_f asg
670: WHERE pro.assignment_id = p_assignment_id
671: AND ppb.pay_basis_id = asg.pay_basis_id
672: AND asg.assignment_id = pro.assignment_id
673: AND p_eff_date BETWEEN asg.effective_start_date