APPS.BEN_DISTRIBUTE_RATES dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 396: from pay_ele_payroll_freq_rules epf

392: l_element_type_id number;
393: --
394: cursor c_element_rule_exists is
395: select 'Y'
396: from pay_ele_payroll_freq_rules epf
397: where epf.element_type_id = l_element_type_id
398: and epf.payroll_id = p_payroll_id
399: and epf.business_group_id = p_business_group_id;
400: --

Line 432: from pay_ele_payroll_freq_rules EPF

428: cursor pay_freq_rule_exists(p_payroll_id IN NUMBER
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

Line 1035: from pay_ele_payroll_freq_rules epf

1031: l_element_type_id number;
1032: --
1033: cursor c_element_rule_exists is
1034: select 'Y'
1035: from pay_ele_payroll_freq_rules epf
1036: where epf.element_type_id = l_element_type_id
1037: and epf.payroll_id = p_payroll_id
1038: and epf.business_group_id = p_business_group_id;
1039: --

Line 1073: from pay_ele_payroll_freq_rules EPF

1069: cursor pay_freq_rule_exists(p_payroll_id IN NUMBER
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