APPS.HR_CA_FF_UDFS dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 2749: FROM pay_ele_payroll_freq_rules EPF

2745: --
2746: hr_utility.set_location('check_dedn_freq', 45);
2747: SELECT COUNT(0)
2748: INTO v_freq_rule_exists
2749: FROM pay_ele_payroll_freq_rules EPF
2750: WHERE element_type_id = p_ele_type_id
2751: AND payroll_id = p_payroll_id
2752: AND business_group_id + 0 = p_bg_id;
2753:

Line 2815: FROM pay_ele_payroll_freq_rules EPF,

2811:
2812: hr_utility.set_location('check_dedn_freq', 50);
2813: SELECT 'N'
2814: INTO v_skip_element
2815: FROM pay_ele_payroll_freq_rules EPF,
2816: pay_freq_rule_periods FRP
2817: WHERE FRP.period_no_in_reset_period = v_run_number
2818: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
2819: AND EPF.business_group_id + 0 = p_bg_id

Line 3814: pay_ele_payroll_freq_rules EPF

3810: hr_utility.set_location('Dedn_Freq_Factor', 10);
3811: SELECT DECODE(COUNT(FRP.freq_rule_period_id), 0, 'N', 'Y')
3812: INTO v_freq_rules_exist
3813: FROM pay_freq_rule_periods FRP,
3814: pay_ele_payroll_freq_rules EPF
3815: WHERE FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
3816: AND EPF.element_type_id = p_element_type_id
3817: AND EPF.payroll_id = p_payroll_id
3818: AND EPF.start_date <= p_date_earned;

Line 3887: FROM pay_ele_payroll_freq_rules EPF,

3883: --
3884: hr_utility.set_location('Dedn_Freq_Factor', 65);
3885: SELECT COUNT(0)
3886: INTO v_pay_periods_in_reset
3887: FROM pay_ele_payroll_freq_rules EPF,
3888: pay_freq_rule_periods FRP
3889: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_month
3890: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
3891: AND EPF.payroll_id = p_payroll_id

Line 3923: FROM pay_ele_payroll_freq_rules EPF,

3919: --
3920: hr_utility.set_location('Dedn_Freq_Factor', 75);
3921: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
3922: INTO v_pay_periods_in_reset
3923: FROM pay_ele_payroll_freq_rules EPF,
3924: pay_freq_rule_periods FRP
3925: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_year
3926: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
3927: AND EPF.payroll_id = p_payroll_id