APPS.PAY_INPUT_VALUES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1735: FROM pay_element_types_f E, pay_input_values_F I

1731: is
1732: result varchar2(255);
1733: Begin
1734: SELECT count(*) INTO result
1735: FROM pay_element_types_f E, pay_input_values_F I
1736: WHERE I.ELEMENT_TYPE_ID = E.ELEMENT_TYPE_ID
1737: and nvl(E.ELEMENT_NAME,'~null~') = nvl(X_I_E_ELEMENT_NAME,'~null~')
1738: and nvl(E.LEGISLATION_CODE,'~null~') = nvl(X_I_E_LEGISLATION_CODE,'~null~')
1739: and E.EFFECTIVE_START_DATE = X_I_E_EFFECTIVE_START_DATE

Line 1783: from pay_element_types_f e

1779: -- statement.
1780: --
1781: cursor csr_ipv_id is
1782: select i.input_value_id
1783: from pay_element_types_f e
1784: , pay_input_values_f i
1785: WHERE i.element_type_id = e.element_type_id
1786: and nvl(e.element_name,'~null~') = nvl(x_i_e_element_name,'~null~')
1787: and nvl(e.legislation_code,'~null~') = nvl(x_i_e_legislation_code,'~null~')