DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on PAY_ELEMENT_TYPES_F

Line 67: from pay_element_types_F

63: FUNCTION Get_Element_Type_Id(p_element_name IN VARCHAR2)
64: RETURN NUMBER IS
65: cursor Csr_Get_Element_Type_Id(l_element_name varchar2) IS
66: select element_type_id
67: from pay_element_types_F
68: where element_name = l_element_name
69: and legislation_code = 'NL';
70: l_Element_Type_Id pay_element_types_F.element_type_id%TYPE;
71: BEGIN

Line 70: l_Element_Type_Id pay_element_types_F.element_type_id%TYPE;

66: select element_type_id
67: from pay_element_types_F
68: where element_name = l_element_name
69: and legislation_code = 'NL';
70: l_Element_Type_Id pay_element_types_F.element_type_id%TYPE;
71: BEGIN
72: OPEN Csr_Get_Element_Type_Id(p_element_name);
73: FETCH Csr_Get_Element_Type_Id INTO l_Element_Type_Id;
74: CLOSE Csr_Get_Element_Type_Id;