APPS.HR_US_FF_UDFS dependencies on PAY_FREQ_RULE_PERIODS

Line 4234: FROM pay_freq_rule_periods FRP,

4230:
4231: hr_utility.set_location('Dedn_Freq_Factor', 10);
4232: SELECT DECODE(COUNT(FRP.freq_rule_period_id), 0, 'N', 'Y')
4233: INTO v_freq_rules_exist
4234: FROM pay_freq_rule_periods FRP,
4235: pay_ele_payroll_freq_rules EPF
4236: WHERE FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4237: AND EPF.element_type_id = p_element_type_id
4238: AND EPF.payroll_id = p_payroll_id

Line 4284: pay_freq_rule_periods FRP

4280: hr_utility.set_location('Dedn_Freq_Factor', 25);
4281: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
4282: INTO v_pay_periods_in_reset
4283: FROM pay_ele_payroll_freq_rules EPF,
4284: pay_freq_rule_periods FRP
4285: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_month
4286: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4287: AND EPF.payroll_id = p_payroll_id
4288: AND EPF.element_type_id = p_element_type_id;

Line 4312: pay_freq_rule_periods FRP

4308: hr_utility.set_location('Dedn_Freq_Factor', 35);
4309: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
4310: INTO v_pay_periods_in_reset
4311: FROM pay_ele_payroll_freq_rules EPF,
4312: pay_freq_rule_periods FRP
4313: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_year
4314: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4315: AND EPF.payroll_id = p_payroll_id
4316: AND EPF.element_type_id = p_element_type_id;

Line 4379: pay_freq_rule_periods FRP

4375: hr_utility.set_location('Dedn_Freq_Factor', 65);
4376: SELECT COUNT(0)
4377: INTO v_pay_periods_in_reset
4378: FROM pay_ele_payroll_freq_rules EPF,
4379: pay_freq_rule_periods FRP
4380: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_month
4381: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4382: AND EPF.payroll_id = p_payroll_id
4383: AND EPF.element_type_id = p_element_type_id;

Line 4415: pay_freq_rule_periods FRP

4411: hr_utility.set_location('Dedn_Freq_Factor', 75);
4412: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
4413: INTO v_pay_periods_in_reset
4414: FROM pay_ele_payroll_freq_rules EPF,
4415: pay_freq_rule_periods FRP
4416: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_year
4417: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4418: AND EPF.payroll_id = p_payroll_id
4419: AND EPF.element_type_id = p_element_type_id;