APPS.GHR_US_NFC_EXTRACTS dependencies on PER_TIME_PERIODS

Line 259: FROM per_time_periods ptp

255: ,cp_effective_date DATE
256: )
257: IS
258: SELECT ptp.period_num
259: FROM per_time_periods ptp
260: WHERE ptp.payroll_id=p_payroll_id
261: AND cp_effective_date BETWEEN ptp.start_date
262: AND ptp.end_date;
263:

Line 298: FROM per_time_periods ptp

294: SELECT ptp.period_num
295: ,ptp.start_date start_date
296: ,ptp.end_date end_date
297: ,paa.position_id
298: FROM per_time_periods ptp
299: ,per_all_assignments_f paa
300: WHERE paa.assignment_id = cp_assignment_id
301: AND paa.business_group_id = cp_business_group_id
302: AND cp_effective_date BETWEEN paa.effective_start_date

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

6682: FUNCTION Get_NFC_ConcProg_Information
6683: (p_header_type IN VARCHAR2
6684: ,p_error_message OUT NOCOPY VARCHAR2) RETURN Varchar2 IS
6685:
6686: CURSOR csr_period_num(c_payroll_id IN per_time_periods.payroll_id%TYPE
6687: ,c_effective_date IN DATE) IS
6688: SELECT period_num
6689: FROM per_time_periods
6690: WHERE payroll_id = c_payroll_id

Line 6689: FROM per_time_periods

6685:
6686: CURSOR csr_period_num(c_payroll_id IN per_time_periods.payroll_id%TYPE
6687: ,c_effective_date IN DATE) IS
6688: SELECT period_num
6689: FROM per_time_periods
6690: WHERE payroll_id = c_payroll_id
6691: AND c_effective_date BETWEEN start_date
6692: AND end_date;
6693:

Line 6706: l_period_num per_time_periods.period_num%TYPE;

6702:
6703: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_NFC_ConcProg_Information';
6704: l_return_value VARCHAR2(1000);
6705: i per_all_assignments_f.business_group_id%TYPE;
6706: l_period_num per_time_periods.period_num%TYPE;
6707: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
6708: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
6709: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
6710: l_start_date DATE;