DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 1048: ,per_periods_of_service pps

1044: --
1045: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
1046: SELECT max(date_start)
1047: FROM per_all_assignments_f asg
1048: ,per_periods_of_service pps
1049: WHERE pps.person_id = asg.person_id
1050: AND asg.assignment_id = c_asg_id
1051: AND pps.business_group_id = p_business_group_id
1052: AND date_start <= p_date_earned;