APPS.HR_PAY_RATE_SS dependencies on PER_TIME_PERIODS

Line 110: from per_time_periods

106:
107: CURSOR csr_check_mid_pay_period(p_eff_date_csr in date
108: ,p_payroll_id_csr in number) IS
109: select start_date, end_date
110: from per_time_periods
111: where p_eff_date_csr > start_date
112: and p_eff_date_csr <= end_date
113: and payroll_id = p_payroll_id_csr;
114:

Line 2078: lv_payroll_status per_time_periods.status%TYPE;

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);
2082: temp VARCHAR2(100);

Line 2236: per_time_periods ptp,

2232: CURSOR c_assignment_status IS
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')

Line 2261: FROM per_time_periods

2257: pspp.effective_start_date and pspp.effective_end_date ;
2258:
2259: CURSOR c_payroll_period ( p_payroll_id NUMBER ) IS
2260: SELECT start_date
2261: FROM per_time_periods
2262: WHERE trunc(sysdate) between start_date and end_date
2263: AND payroll_id = p_payroll_id;
2264:
2265: l_pay_proposal_id NUMBER ;

Line 2277: lv_payroll_status per_time_periods.status%TYPE;

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) := '';
2281: temp VARCHAR2(100) := '';