APPS.HR_CA_FF_UDFS dependencies on PER_TIME_PERIODS

Line 2763: FROM per_time_periods

2759: -- Get payroll period type.number per fiscal year.
2760: --
2761: SELECT end_date
2762: INTO v_period_end_date
2763: FROM per_time_periods
2764: WHERE p_date_earned BETWEEN start_date AND end_date
2765: AND payroll_id = p_payroll_id;
2766:
2767: SELECT TPT.number_per_fiscal_year

Line 2784: FROM per_time_periods PTP

2780: hr_utility.set_location('check_dedn_freq', 20);
2781:
2782: SELECT COUNT(0)
2783: INTO v_run_number
2784: FROM per_time_periods PTP
2785: WHERE PTP.end_date
2786: BETWEEN TRUNC(p_date_earned,'YEAR')
2787: AND v_period_end_date
2788: AND PTP.payroll_id = p_payroll_id;

Line 2795: FROM per_time_periods PTP

2791: hr_utility.set_location('check_dedn_freq', 30);
2792:
2793: SELECT COUNT(0)
2794: INTO v_run_number
2795: FROM per_time_periods PTP
2796: WHERE PTP.end_date
2797: BETWEEN TRUNC(p_date_earned,'MONTH')
2798: AND v_period_end_date
2799: AND PTP.payroll_id = p_payroll_id;

Line 3286: from per_time_periods

3282: select start_date,
3283: end_date
3284: into v_range_start,
3285: v_range_end
3286: from per_time_periods
3287: where payroll_id = p_pay_id
3288: and p_date_earned between start_date and end_date;
3289:
3290: OPEN cur_element_type_id('Regular Salary');

Line 3874: FROM per_time_periods PTP

3870: IF v_pay_period_num_per_fy >= 12 THEN
3871: hr_utility.set_location('Dedn_Freq_Factor', 60);
3872: SELECT COUNT(0)
3873: INTO v_pay_periods_in_month
3874: FROM per_time_periods PTP
3875: WHERE PTP.end_date
3876: BETWEEN TRUNC(p_date_earned, 'MONTH')
3877: AND LAST_DAY(p_date_earned)
3878: AND PTP.payroll_id = p_payroll_id;

Line 3910: FROM per_time_periods PTP

3906: ELSE
3907: hr_utility.set_location('Dedn_Freq_Factor', 70);
3908: SELECT COUNT(0)
3909: INTO v_pay_periods_in_year
3910: FROM per_time_periods PTP
3911: WHERE PTP.end_date
3912: BETWEEN TRUNC(p_date_earned,'YEAR')
3913: AND LAST_DAY(ADD_MONTHS(TRUNC(p_date_earned,'YEAR'), 11))
3914: AND PTP.payroll_id = p_payroll_id;