APPS.HR_US_FF_UDFS dependencies on PAY_FREQ_RULE_PERIODS

Line 4225: FROM pay_freq_rule_periods FRP,

4221:
4222: hr_utility.set_location('Dedn_Freq_Factor', 10);
4223: SELECT DECODE(COUNT(FRP.freq_rule_period_id), 0, 'N', 'Y')
4224: INTO v_freq_rules_exist
4225: FROM pay_freq_rule_periods FRP,
4226: pay_ele_payroll_freq_rules EPF
4227: WHERE FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4228: AND EPF.element_type_id = p_element_type_id
4229: AND EPF.payroll_id = p_payroll_id

Line 4275: pay_freq_rule_periods FRP

4271: hr_utility.set_location('Dedn_Freq_Factor', 25);
4272: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
4273: INTO v_pay_periods_in_reset
4274: FROM pay_ele_payroll_freq_rules EPF,
4275: pay_freq_rule_periods FRP
4276: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_month
4277: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4278: AND EPF.payroll_id = p_payroll_id
4279: AND EPF.element_type_id = p_element_type_id;

Line 4303: pay_freq_rule_periods FRP

4299: hr_utility.set_location('Dedn_Freq_Factor', 35);
4300: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
4301: INTO v_pay_periods_in_reset
4302: FROM pay_ele_payroll_freq_rules EPF,
4303: pay_freq_rule_periods FRP
4304: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_year
4305: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4306: AND EPF.payroll_id = p_payroll_id
4307: AND EPF.element_type_id = p_element_type_id;

Line 4370: pay_freq_rule_periods FRP

4366: hr_utility.set_location('Dedn_Freq_Factor', 65);
4367: SELECT COUNT(0)
4368: INTO v_pay_periods_in_reset
4369: FROM pay_ele_payroll_freq_rules EPF,
4370: pay_freq_rule_periods FRP
4371: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_month
4372: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4373: AND EPF.payroll_id = p_payroll_id
4374: AND EPF.element_type_id = p_element_type_id;

Line 4406: pay_freq_rule_periods FRP

4402: hr_utility.set_location('Dedn_Freq_Factor', 75);
4403: SELECT DECODE(COUNT(0), 0, 1, COUNT(0))
4404: INTO v_pay_periods_in_reset
4405: FROM pay_ele_payroll_freq_rules EPF,
4406: pay_freq_rule_periods FRP
4407: WHERE FRP.period_no_in_reset_period <= v_pay_periods_in_year
4408: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
4409: AND EPF.payroll_id = p_payroll_id
4410: AND EPF.element_type_id = p_element_type_id;