APPS.BEN_DISTRIBUTE_RATES dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 430: from pay_ele_payroll_freq_rules epf

426: l_element_type_id number;
427: --
428: cursor c_element_rule_exists is
429: select 'Y'
430: from pay_ele_payroll_freq_rules epf
431: where epf.element_type_id = l_element_type_id
432: and epf.payroll_id = p_payroll_id
433: and epf.business_group_id = p_business_group_id;
434: --

Line 466: from pay_ele_payroll_freq_rules EPF

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

Line 1075: from pay_ele_payroll_freq_rules epf

1071: l_element_type_id number;
1072: --
1073: cursor c_element_rule_exists is
1074: select 'Y'
1075: from pay_ele_payroll_freq_rules epf
1076: where epf.element_type_id = l_element_type_id
1077: and epf.payroll_id = p_payroll_id
1078: and epf.business_group_id = p_business_group_id;
1079: --

Line 1113: from pay_ele_payroll_freq_rules EPF

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