APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1053: per_assignment_status_types ast

1049: SELECT asg.effective_start_date,
1050: asg.effective_end_date,
1051: ast.per_system_status
1052: FROM per_all_assignments_f asg,
1053: per_assignment_status_types ast
1054: WHERE asg.assignment_id = p_assignment_id
1055: AND ((asg.effective_start_date BETWEEN p_period_sd AND p_period_ed
1056: OR asg.effective_end_date BETWEEN p_period_sd AND p_period_ed)
1057: OR (p_period_sd BETWEEN asg.effective_start_date AND asg.effective_end_date))

Line 1064: l_assignment_status per_assignment_status_types.per_system_status%TYPE;

1060:
1061: l_proc VARCHAR2(72) := g_package||'get_loa_days';
1062: l_assignment_sd DATE;
1063: l_assignment_ed DATE;
1064: l_assignment_status per_assignment_status_types.per_system_status%TYPE;
1065: l_asg_inactive_days NUMBER := 0;
1066:
1067: BEGIN
1068: --