APPS.PAY_PYEPFREQ_PKG dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 87: FROM pay_ele_payroll_freq_rules EPF,

83: begin
84: --
85: SELECT 'Y'
86: INTO v_freq_rule_exists
87: FROM pay_ele_payroll_freq_rules EPF,
88: pay_freq_rule_periods FRP
89: WHERE FRP.period_no_in_reset_period = p_period_num
90: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
91: AND EPF.business_group_id + 0 = p_bus_grp_id

Line 123: FROM pay_ele_payroll_freq_rules

119: hr_utility.set_location('pay_pyepfreq_pkg', 10);
120:
121: SELECT ele_payroll_freq_rule_id
122: INTO v_ele_pay_freq_rule_id
123: FROM pay_ele_payroll_freq_rules
124: WHERE element_type_id = p_eletype_id
125: AND payroll_id = p_payroll_id
126: AND business_group_id + 0 = p_bg_id;
127: --

Line 129: DELETE FROM pay_ele_payroll_freq_rules

125: AND payroll_id = p_payroll_id
126: AND business_group_id + 0 = p_bg_id;
127: --
128: hr_utility.set_location('pay_pyepfreq_pkg', 20);
129: DELETE FROM pay_ele_payroll_freq_rules
130: WHERE ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;
131: --
132: hr_utility.set_location('pay_pyepfreq_pkg', 30);
133: DELETE FROM pay_freq_rule_periods

Line 180: SELECT pay_ele_payroll_freq_rules_s.nextval

176: UPPER(p_period_4) = 'Y' or
177: UPPER(p_period_5) = 'Y' )
178: then
179: hr_utility.set_location('pay_pyepfreq_pkg', 50);
180: SELECT pay_ele_payroll_freq_rules_s.nextval
181: INTO v_ele_pay_freq_rule_id
182: FROM sys.dual;
183: --
184: hr_utility.set_location('pay_pyepfreq_pkg', 60);

Line 185: INSERT INTO pay_ele_payroll_freq_rules (

181: INTO v_ele_pay_freq_rule_id
182: FROM sys.dual;
183: --
184: hr_utility.set_location('pay_pyepfreq_pkg', 60);
185: INSERT INTO pay_ele_payroll_freq_rules (
186: ele_payroll_freq_rule_id,
187: element_type_id,
188: payroll_id,
189: business_group_id,

Line 328: FROM pay_ele_payroll_freq_rules EPF,

324: cp_bg_id number,
325: cp_period_num number)
326: IS
327: SELECT 'Y', EPF.rule_date_code
328: FROM pay_ele_payroll_freq_rules EPF,
329: pay_freq_rule_periods FRP
330: WHERE FRP.period_no_in_reset_period = cp_period_num
331: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
332: AND EPF.business_group_id + 0 = cp_bg_id