APPS.BEN_DISTRIBUTE_RATES dependencies on PAY_FREQ_RULE_PERIODS

Line 467: , pay_freq_rule_periods FRP

463: ,p_element_type_id IN NUMBER) is
464: select sum(power(2,(FRP.period_no_in_reset_period) - 1))
465: ,decode(epf.reset_period_type,'Year','YYYY','MM')
466: from pay_ele_payroll_freq_rules EPF
467: , pay_freq_rule_periods FRP
468: where FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
469: and EPF.payroll_id = p_payroll_id
470: and EPF.element_type_id = p_element_type_id
471: group by epf.ele_payroll_freq_rule_id ,epf.reset_period_type;

Line 1114: , pay_freq_rule_periods FRP

1110: ,p_element_type_id IN NUMBER) is
1111: select sum(power(2,(FRP.period_no_in_reset_period) - 1))
1112: ,decode(epf.reset_period_type,'Year','YYYY','MM')
1113: from pay_ele_payroll_freq_rules EPF
1114: , pay_freq_rule_periods FRP
1115: where FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
1116: and EPF.payroll_id = p_payroll_id
1117: and EPF.element_type_id = p_element_type_id
1118: group by epf.ele_payroll_freq_rule_id ,epf.reset_period_type;