APPS.PAY_CA_ROE_EI_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 61: FROM per_periods_of_service service,

57: CURSOR csr_rehire_date (p_asg_id NUMBER,
58: p_end_date DATE,
59: p_start_date DATE) IS
60: SELECT MAX(service.date_start) hire_date
61: FROM per_periods_of_service service,
62: per_assignments_f asg
63: WHERE asg.assignment_id = p_asg_id
64: AND p_end_date BETWEEN
65: asg.effective_start_date

Line 1074: from per_periods_of_service service,

1070: l_start_date1 DATE;
1071:
1072: cursor cur_date_of_hire is
1073: select max(service.date_start) hire_date
1074: from per_periods_of_service service,
1075: per_assignments_f asg
1076: where asg.assignment_id = p_assignment_id
1077: and p_end_date BETWEEN
1078: asg.effective_start_date