APPS.HR_CA_FF_UDFS dependencies on PAY_FREQ_RULE_PERIODS

Line 2853: pay_freq_rule_periods FRP

2849: hr_utility.set_location('check_dedn_freq', 50);
2850: SELECT 'N'
2851: INTO v_skip_element
2852: FROM pay_ele_payroll_freq_rules EPF,
2853: pay_freq_rule_periods FRP
2854: WHERE FRP.period_no_in_reset_period = v_run_number
2855: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
2856: AND EPF.business_group_id + 0 = p_bg_id
2857: AND EPF.payroll_id = p_payroll_id

Line 3850: FROM pay_freq_rule_periods FRP,

3846: --
3847: hr_utility.set_location('Dedn_Freq_Factor', 10);
3848: SELECT DECODE(COUNT(FRP.freq_rule_period_id), 0, 'N', 'Y')
3849: INTO v_freq_rules_exist
3850: FROM pay_freq_rule_periods FRP,
3851: pay_ele_payroll_freq_rules EPF
3852: WHERE FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
3853: AND EPF.element_type_id = p_element_type_id
3854: AND EPF.payroll_id = p_payroll_id

Line 3925: pay_freq_rule_periods FRP

3921: hr_utility.set_location('Dedn_Freq_Factor', 65);
3922: SELECT COUNT(0)
3923: INTO v_pay_periods_in_reset
3924: FROM pay_ele_payroll_freq_rules EPF,
3925: pay_freq_rule_periods FRP
3926: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_month
3927: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
3928: AND EPF.payroll_id = p_payroll_id
3929: AND EPF.element_type_id = p_element_type_id;

Line 3961: pay_freq_rule_periods FRP

3957: hr_utility.set_location('Dedn_Freq_Factor', 75);
3958: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
3959: INTO v_pay_periods_in_reset
3960: FROM pay_ele_payroll_freq_rules EPF,
3961: pay_freq_rule_periods FRP
3962: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_year
3963: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
3964: AND EPF.payroll_id = p_payroll_id
3965: AND EPF.element_type_id = p_element_type_id;