APPS.HR_CA_FF_UDFS dependencies on PAY_FREQ_RULE_PERIODS

Line 2816: pay_freq_rule_periods FRP

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
2820: AND EPF.payroll_id = p_payroll_id

Line 3813: FROM pay_freq_rule_periods FRP,

3809: --
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

Line 3888: pay_freq_rule_periods FRP

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
3892: AND EPF.element_type_id = p_element_type_id;

Line 3924: pay_freq_rule_periods FRP

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
3928: AND EPF.element_type_id = p_element_type_id;