APPS.HR_US_FF_UDFS dependencies on PER_TIME_PERIODS

Line 3673: from per_time_periods

3669: select start_date,
3670: end_date
3671: into v_range_start,
3672: v_range_end
3673: from per_time_periods
3674: where payroll_id = p_pay_id
3675: and p_date_earned between start_date and end_date;
3676:
3677: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(

Line 4260: FROM per_time_periods PTP

4256: ELSE
4257: hr_utility.set_location('Dedn_Freq_Factor', 20);
4258: SELECT COUNT(0)
4259: INTO v_pay_periods_in_month
4260: FROM per_time_periods PTP
4261: WHERE PTP.end_date
4262: BETWEEN TRUNC(p_date_earned, 'MONTH')
4263: AND LAST_DAY(p_date_earned)
4264: AND PTP.payroll_id = p_payroll_id;

Line 4289: FROM per_time_periods PTP

4285: ELSE
4286: hr_utility.set_location('Dedn_Freq_Factor', 30);
4287: SELECT COUNT(0)
4288: INTO v_pay_periods_in_year
4289: FROM per_time_periods PTP
4290: WHERE PTP.end_date
4291: BETWEEN TRUNC(p_date_earned, 'YEAR')
4292: AND LAST_DAY(ADD_MONTHS(TRUNC(p_date_earned, 'YEAR'), 11))
4293: AND PTP.payroll_id = p_payroll_id;

Line 4356: FROM per_time_periods PTP

4352: IF v_pay_period_num_per_fy >= 12 THEN
4353: hr_utility.set_location('Dedn_Freq_Factor', 60);
4354: SELECT COUNT(0)
4355: INTO v_pay_periods_in_month
4356: FROM per_time_periods PTP
4357: WHERE PTP.end_date
4358: BETWEEN TRUNC(p_date_earned, 'MONTH')
4359: AND LAST_DAY(p_date_earned)
4360: AND PTP.payroll_id = p_payroll_id;

Line 4392: FROM per_time_periods PTP

4388: ELSE
4389: hr_utility.set_location('Dedn_Freq_Factor', 70);
4390: SELECT COUNT(0)
4391: INTO v_pay_periods_in_year
4392: FROM per_time_periods PTP
4393: WHERE PTP.end_date
4394: BETWEEN TRUNC(p_date_earned, 'YEAR')
4395: AND LAST_DAY(ADD_MONTHS(TRUNC(p_date_earned, 'YEAR'), 11))
4396: AND PTP.payroll_id = p_payroll_id;