APPS.HR_CA_FF_UDFS dependencies on PER_TIME_PERIODS

Line 2800: FROM per_time_periods

2796: -- Get payroll period type.number per fiscal year.
2797: --
2798: SELECT end_date
2799: INTO v_period_end_date
2800: FROM per_time_periods
2801: WHERE p_date_earned BETWEEN start_date AND end_date
2802: AND payroll_id = p_payroll_id;
2803:
2804: SELECT TPT.number_per_fiscal_year

Line 2821: FROM per_time_periods PTP

2817: hr_utility.set_location('check_dedn_freq', 20);
2818:
2819: SELECT COUNT(0)
2820: INTO v_run_number
2821: FROM per_time_periods PTP
2822: WHERE PTP.end_date
2823: BETWEEN TRUNC(p_date_earned,'YEAR')
2824: AND v_period_end_date
2825: AND PTP.payroll_id = p_payroll_id;

Line 2832: FROM per_time_periods PTP

2828: hr_utility.set_location('check_dedn_freq', 30);
2829:
2830: SELECT COUNT(0)
2831: INTO v_run_number
2832: FROM per_time_periods PTP
2833: WHERE PTP.end_date
2834: BETWEEN TRUNC(p_date_earned,'MONTH')
2835: AND v_period_end_date
2836: AND PTP.payroll_id = p_payroll_id;

Line 3323: from per_time_periods

3319: select start_date,
3320: end_date
3321: into v_range_start,
3322: v_range_end
3323: from per_time_periods
3324: where payroll_id = p_pay_id
3325: and p_date_earned between start_date and end_date;
3326:
3327: OPEN cur_element_type_id('Regular Salary');

Line 3911: FROM per_time_periods PTP

3907: IF v_pay_period_num_per_fy >= 12 THEN
3908: hr_utility.set_location('Dedn_Freq_Factor', 60);
3909: SELECT COUNT(0)
3910: INTO v_pay_periods_in_month
3911: FROM per_time_periods PTP
3912: WHERE PTP.end_date
3913: BETWEEN TRUNC(p_date_earned, 'MONTH')
3914: AND LAST_DAY(p_date_earned)
3915: AND PTP.payroll_id = p_payroll_id;

Line 3947: FROM per_time_periods PTP

3943: ELSE
3944: hr_utility.set_location('Dedn_Freq_Factor', 70);
3945: SELECT COUNT(0)
3946: INTO v_pay_periods_in_year
3947: FROM per_time_periods PTP
3948: WHERE PTP.end_date
3949: BETWEEN TRUNC(p_date_earned,'YEAR')
3950: AND LAST_DAY(ADD_MONTHS(TRUNC(p_date_earned,'YEAR'), 11))
3951: AND PTP.payroll_id = p_payroll_id;