APPS.HR_US_FF_UDFS dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 4235: pay_ele_payroll_freq_rules EPF

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
4239: AND EPF.start_date <= p_date_earned;

Line 4283: FROM pay_ele_payroll_freq_rules EPF,

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

Line 4311: FROM pay_ele_payroll_freq_rules EPF,

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

Line 4378: FROM pay_ele_payroll_freq_rules EPF,

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

Line 4414: FROM pay_ele_payroll_freq_rules EPF,

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