APPS.HR_PAY_RATE_SS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2077: per_assignment_status_types.per_system_status%TYPE;

2073: l_review_date DATE ;
2074: l_multiple_components Varchar2(1) ;
2075: ln_ovn NUMBER ;
2076: lv_system_status
2077: per_assignment_status_types.per_system_status%TYPE;
2078: lv_payroll_status per_time_periods.status%TYPE;
2079: lv_exists VARCHAR2(1);
2080: ld_payroll_start_date DATE ;
2081: message VARCHAR2(500);

Line 2237: per_assignment_status_types ast

2233: SELECT ast.per_system_status,
2234: ptp.status
2235: FROM per_all_assignments_f asg,
2236: per_time_periods ptp,
2237: per_assignment_status_types ast
2238: WHERE asg.assignment_id = p_assignment_id
2239: AND asg.assignment_status_type_id = ast.assignment_status_type_id
2240: AND to_date(p_effective_date,'RRRR-MM-DD')
2241: between asg.effective_start_date

Line 2276: per_assignment_status_types.per_system_status%TYPE;

2272: l_review_date DATE ;
2273: l_multiple_components Varchar2(1) ;
2274: ln_ovn NUMBER ;
2275: lv_system_status
2276: per_assignment_status_types.per_system_status%TYPE;
2277: lv_payroll_status per_time_periods.status%TYPE;
2278: lv_exists VARCHAR2(1);
2279: ld_payroll_start_date DATE ;
2280: message VARCHAR2(500) := '';