APPS.HR_ELEMENTS dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 1641: FROM pay_ele_payroll_freq_rules EPF

1637: hr_utility.set_location('check_element_freq', 45);
1638: end if;
1639: SELECT COUNT(0)
1640: INTO v_freq_rule_exists
1641: FROM pay_ele_payroll_freq_rules EPF
1642: WHERE element_type_id = p_ele_type_id
1643: AND payroll_id = p_payroll_id
1644: AND business_group_id + 0 = p_bg_id;
1645:

Line 1653: FROM pay_ele_payroll_freq_rules

1649: END IF;
1650:
1651: SELECT NVL(rule_date_code,'E')
1652: INTO v_rule_date_code
1653: FROM pay_ele_payroll_freq_rules
1654: WHERE element_type_id = p_ele_type_id
1655: AND payroll_id = p_payroll_id;
1656:
1657: --

Line 1859: FROM pay_ele_payroll_freq_rules EPF,

1855: hr_utility.set_location('check_element_freq', 50);
1856: end if;
1857: SELECT 'N'
1858: INTO p_skip_element
1859: FROM pay_ele_payroll_freq_rules EPF,
1860: pay_freq_rule_periods FRP
1861: WHERE FRP.period_no_in_reset_period = v_run_number
1862: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
1863: AND EPF.business_group_id + 0 = p_bg_id