DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on PAY_FREQ_RULE_PERIODS

Line 433: , pay_freq_rule_periods FRP

429: ,p_element_type_id IN NUMBER) is
430: select sum(power(2,(FRP.period_no_in_reset_period) - 1))
431: ,decode(epf.reset_period_type,'Year','YYYY','MM')
432: from pay_ele_payroll_freq_rules EPF
433: , pay_freq_rule_periods FRP
434: where FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
435: and EPF.payroll_id = p_payroll_id
436: and EPF.element_type_id = p_element_type_id
437: group by epf.ele_payroll_freq_rule_id ,epf.reset_period_type;

Line 1074: , pay_freq_rule_periods FRP

1070: ,p_element_type_id IN NUMBER) is
1071: select sum(power(2,(FRP.period_no_in_reset_period) - 1))
1072: ,decode(epf.reset_period_type,'Year','YYYY','MM')
1073: from pay_ele_payroll_freq_rules EPF
1074: , pay_freq_rule_periods FRP
1075: where FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
1076: and EPF.payroll_id = p_payroll_id
1077: and EPF.element_type_id = p_element_type_id
1078: group by epf.ele_payroll_freq_rule_id ,epf.reset_period_type;