APPS.PAY_PYEPFREQ_PKG dependencies on PAY_FREQ_RULE_PERIODS

Line 43: SELECT pay_freq_rule_periods_s.nextval

39: v_freq_rule_pd_id NUMBER(9);
40:
41: BEGIN
42: --
43: SELECT pay_freq_rule_periods_s.nextval
44: INTO v_freq_rule_pd_id
45: FROM sys.dual;
46: --
47: INSERT INTO pay_freq_rule_periods (

Line 47: INSERT INTO pay_freq_rule_periods (

43: SELECT pay_freq_rule_periods_s.nextval
44: INTO v_freq_rule_pd_id
45: FROM sys.dual;
46: --
47: INSERT INTO pay_freq_rule_periods (
48: freq_rule_period_id,
49: ele_payroll_freq_rule_id,
50: business_group_id,
51: period_no_in_reset_period,

Line 88: pay_freq_rule_periods FRP

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
92: AND EPF.payroll_id = p_pay_id

Line 133: DELETE FROM pay_freq_rule_periods

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
134: WHERE ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;
135: --
136: -- If either of the above fail, then it's ok, we're just cleaning up
137: -- before insertion of "new" rule.

Line 329: pay_freq_rule_periods FRP

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
333: AND EPF.payroll_id = cp_payroll_id