APPS.HR_US_FF_UDFS dependencies on PER_TIME_PERIODS

Line 3682: from per_time_periods

3678: select start_date,
3679: end_date
3680: into v_range_start,
3681: v_range_end
3682: from per_time_periods
3683: where payroll_id = p_pay_id
3684: and p_date_earned between start_date and end_date;
3685:
3686: v_pay_basis_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hr_us_ff_udfs.convert_period_type(

Line 4269: FROM per_time_periods PTP

4265: ELSE
4266: hr_utility.set_location('Dedn_Freq_Factor', 20);
4267: SELECT COUNT(0)
4268: INTO v_pay_periods_in_month
4269: FROM per_time_periods PTP
4270: WHERE PTP.end_date
4271: BETWEEN TRUNC(p_date_earned, 'MONTH')
4272: AND LAST_DAY(p_date_earned)
4273: AND PTP.payroll_id = p_payroll_id;

Line 4298: FROM per_time_periods PTP

4294: ELSE
4295: hr_utility.set_location('Dedn_Freq_Factor', 30);
4296: SELECT COUNT(0)
4297: INTO v_pay_periods_in_year
4298: FROM per_time_periods PTP
4299: WHERE PTP.end_date
4300: BETWEEN TRUNC(p_date_earned, 'YEAR')
4301: AND LAST_DAY(ADD_MONTHS(TRUNC(p_date_earned, 'YEAR'), 11))
4302: AND PTP.payroll_id = p_payroll_id;

Line 4365: FROM per_time_periods PTP

4361: IF v_pay_period_num_per_fy >= 12 THEN
4362: hr_utility.set_location('Dedn_Freq_Factor', 60);
4363: SELECT COUNT(0)
4364: INTO v_pay_periods_in_month
4365: FROM per_time_periods PTP
4366: WHERE PTP.end_date
4367: BETWEEN TRUNC(p_date_earned, 'MONTH')
4368: AND LAST_DAY(p_date_earned)
4369: AND PTP.payroll_id = p_payroll_id;

Line 4401: FROM per_time_periods PTP

4397: ELSE
4398: hr_utility.set_location('Dedn_Freq_Factor', 70);
4399: SELECT COUNT(0)
4400: INTO v_pay_periods_in_year
4401: FROM per_time_periods PTP
4402: WHERE PTP.end_date
4403: BETWEEN TRUNC(p_date_earned, 'YEAR')
4404: AND LAST_DAY(ADD_MONTHS(TRUNC(p_date_earned, 'YEAR'), 11))
4405: AND PTP.payroll_id = p_payroll_id;