APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 91: , per_assignment_status_types ast

87: -- need to add 1 as to include the finale day
88: -- e.g. 01-JAN-2000 minus 01-JAN-2000 is actually 1 day but the arithmetic returns 0
89: select sum(asg.effective_end_date - asg.effective_start_date + 1) days_inactive
90: from per_assignments_f asg
91: , per_assignment_status_types ast
92: where asg.assignment_id = p_assignment_id
93: and ((asg.effective_start_date between p_period_sd and p_period_ed
94: or asg.effective_end_date between p_period_sd and p_period_ed)
95: or (p_period_sd between asg.effective_start_date and asg.effective_end_date))

Line 1257: ,per_assignment_status_types ast

1253:
1254: select ast.per_system_status,asg.EFFECTIVE_START_DATE,asg.EFFECTIVE_END_DATE
1255: bulk collect into l_system_status, l_eff_start_date, l_eff_end_date
1256: from per_assignments_f asg
1257: ,per_assignment_status_types ast
1258: where asg.assignment_id = p_assignment_id
1259: and asg.assignment_status_type_id = ast.assignment_status_type_id
1260: and ast.per_system_status <> 'ACTIVE_ASSIGN';
1261: