APPS.HR_PAY_RATE_SS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1977: per_assignment_status_types.per_system_status%TYPE;

1973: l_review_date DATE ;
1974: l_multiple_components Varchar2(1) ;
1975: ln_ovn NUMBER ;
1976: lv_system_status
1977: per_assignment_status_types.per_system_status%TYPE;
1978: lv_payroll_status per_time_periods.status%TYPE;
1979: lv_exists VARCHAR2(1);
1980: ld_payroll_start_date DATE ;
1981: message VARCHAR2(500);

Line 2136: per_assignment_status_types ast

2132: SELECT ast.per_system_status,
2133: ptp.status
2134: FROM per_all_assignments_f asg,
2135: per_time_periods ptp,
2136: per_assignment_status_types ast
2137: WHERE asg.assignment_id = p_assignment_id
2138: AND asg.assignment_status_type_id = ast.assignment_status_type_id
2139: AND to_date(p_effective_date,'RRRR-MM-DD')
2140: between asg.effective_start_date

Line 2175: per_assignment_status_types.per_system_status%TYPE;

2171: l_review_date DATE ;
2172: l_multiple_components Varchar2(1) ;
2173: ln_ovn NUMBER ;
2174: lv_system_status
2175: per_assignment_status_types.per_system_status%TYPE;
2176: lv_payroll_status per_time_periods.status%TYPE;
2177: lv_exists VARCHAR2(1);
2178: ld_payroll_start_date DATE ;
2179: message VARCHAR2(500) := '';