APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 978: per_assignment_status_types ast

974: SELECT asg.effective_start_date,
975: asg.effective_end_date,
976: ast.per_system_status
977: FROM per_all_assignments_f asg,
978: per_assignment_status_types ast
979: WHERE asg.assignment_id = p_assignment_id
980: AND ((asg.effective_start_date BETWEEN p_period_sd AND p_period_ed
981: OR asg.effective_end_date BETWEEN p_period_sd AND p_period_ed)
982: OR (p_period_sd BETWEEN asg.effective_start_date AND asg.effective_end_date))

Line 989: l_assignment_status per_assignment_status_types.per_system_status%TYPE;

985:
986: l_proc VARCHAR2(72) := g_package||'get_loa_days';
987: l_assignment_sd DATE;
988: l_assignment_ed DATE;
989: l_assignment_status per_assignment_status_types.per_system_status%TYPE;
990: l_asg_inactive_days NUMBER := 0;
991:
992: BEGIN
993: --