APPS.GHR_NFC_POSITION_EXTRACTS dependencies on PER_TIME_PERIODS

Line 190: FROM per_time_periods ptp

186: ,cp_effective_date DATE
187: )
188: IS
189: SELECT ptp.period_num
190: FROM per_time_periods ptp
191: WHERE ptp.payroll_id=p_payroll_id
192: AND cp_effective_date BETWEEN ptp.start_date
193: AND ptp.end_date;
194:

Line 230: FROM per_time_periods ptp

226: SELECT ptp.period_num
227: ,ptp.start_date start_date
228: ,ptp.end_date end_date
229: ,paa.position_id
230: FROM per_time_periods ptp
231: ,per_all_assignments_f paa
232: WHERE paa.assignment_id = cp_assignment_id
233: AND paa.business_group_id = cp_business_group_id
234: AND cp_effective_date BETWEEN paa.effective_start_date

Line 3317: CURSOR csr_period_num(c_payroll_id IN per_time_periods.payroll_id%TYPE

3313: FUNCTION Get_NFC_ConcProg_Information
3314: (p_header_type IN VARCHAR2
3315: ,p_error_message OUT NOCOPY VARCHAR2) RETURN Varchar2 IS
3316:
3317: CURSOR csr_period_num(c_payroll_id IN per_time_periods.payroll_id%TYPE
3318: ,c_effective_date IN DATE) IS
3319: SELECT period_num
3320: FROM per_time_periods
3321: WHERE payroll_id = c_payroll_id

Line 3320: FROM per_time_periods

3316:
3317: CURSOR csr_period_num(c_payroll_id IN per_time_periods.payroll_id%TYPE
3318: ,c_effective_date IN DATE) IS
3319: SELECT period_num
3320: FROM per_time_periods
3321: WHERE payroll_id = c_payroll_id
3322: AND c_effective_date BETWEEN start_date
3323: AND end_date;
3324:

Line 3345: l_period_num per_time_periods.period_num%TYPE;

3341:
3342: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_NFC_ConcProg_Information';
3343: l_return_value VARCHAR2(1000);
3344: i per_all_assignments_f.business_group_id%TYPE;
3345: l_period_num per_time_periods.period_num%TYPE;
3346: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
3347: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
3348: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
3349: l_position_id NUMBER;