DBA Data[Home] [Help]

APPS.HR_ELEMENTS dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 1640: FROM pay_ele_payroll_freq_rules EPF

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

Line 1763: FROM pay_ele_payroll_freq_rules EPF,

1759: hr_utility.set_location('check_element_freq', 50);
1760: end if;
1761: SELECT 'N'
1762: INTO p_skip_element
1763: FROM pay_ele_payroll_freq_rules EPF,
1764: pay_freq_rule_periods FRP
1765: WHERE FRP.period_no_in_reset_period = v_run_number
1766: AND FRP.ele_payroll_freq_rule_id = EPF.ele_payroll_freq_rule_id
1767: AND EPF.business_group_id + 0 = p_bg_id