APPS.PAY_INPUT_VALUES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1741: FROM pay_element_types_f E, pay_input_values_F I

1737: is
1738: result varchar2(255);
1739: Begin
1740: SELECT count(*) INTO result
1741: FROM pay_element_types_f E, pay_input_values_F I
1742: WHERE I.ELEMENT_TYPE_ID = E.ELEMENT_TYPE_ID
1743: and nvl(E.ELEMENT_NAME,'~null~') = nvl(X_I_E_ELEMENT_NAME,'~null~')
1744: and nvl(E.LEGISLATION_CODE,'~null~') = nvl(X_I_E_LEGISLATION_CODE,'~null~')
1745: and E.EFFECTIVE_START_DATE = X_I_E_EFFECTIVE_START_DATE

Line 1789: from pay_element_types_f e

1785: -- statement.
1786: --
1787: cursor csr_ipv_id is
1788: select i.input_value_id
1789: from pay_element_types_f e
1790: , pay_input_values_f i
1791: WHERE i.element_type_id = e.element_type_id
1792: and nvl(e.element_name,'~null~') = nvl(x_i_e_element_name,'~null~')
1793: and nvl(e.legislation_code,'~null~') = nvl(x_i_e_legislation_code,'~null~')