APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 33: (element_type_id pay_shadow_element_types.element_type_id%TYPE

29: )
30: RETURN NUMBER IS
31: --
32: TYPE shadow_ele_rec IS RECORD
33: (element_type_id pay_shadow_element_types.element_type_id%TYPE
34: ,object_version_NUMBER
35: pay_shadow_element_types.object_version_NUMBER%TYPE
36: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
37: ,description pay_shadow_element_types.description%TYPE

Line 35: pay_shadow_element_types.object_version_NUMBER%TYPE

31: --
32: TYPE shadow_ele_rec IS RECORD
33: (element_type_id pay_shadow_element_types.element_type_id%TYPE
34: ,object_version_NUMBER
35: pay_shadow_element_types.object_version_NUMBER%TYPE
36: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
37: ,description pay_shadow_element_types.description%TYPE
38: );
39: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec

Line 36: ,reporting_name pay_shadow_element_types.reporting_name%TYPE

32: TYPE shadow_ele_rec IS RECORD
33: (element_type_id pay_shadow_element_types.element_type_id%TYPE
34: ,object_version_NUMBER
35: pay_shadow_element_types.object_version_NUMBER%TYPE
36: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
37: ,description pay_shadow_element_types.description%TYPE
38: );
39: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec
40: INDEX BY Binary_Integer;

Line 37: ,description pay_shadow_element_types.description%TYPE

33: (element_type_id pay_shadow_element_types.element_type_id%TYPE
34: ,object_version_NUMBER
35: pay_shadow_element_types.object_version_NUMBER%TYPE
36: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
37: ,description pay_shadow_element_types.description%TYPE
38: );
39: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec
40: INDEX BY Binary_Integer;
41:

Line 116: l_template_id pay_shadow_element_types.template_id%TYPE;

112: l_abs_text VARCHAR2(32767);
113: l_dbi_user_name ff_database_items.user_name%TYPE;
114: l_balance_name pay_balance_types.balance_name%TYPE;
115: l_balance_dbi_name ff_database_items.user_name%TYPE;
116: l_template_id pay_shadow_element_types.template_id%TYPE;
117: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
118: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 156: FROM pay_shadow_element_types

152: --
153: CURSOR csr_get_ele_info (c_ele_name VARCHAR2) IS
154: SELECT element_type_id
155: ,object_version_NUMBER
156: FROM pay_shadow_element_types
157: WHERE template_id = l_template_id
158: AND element_name = c_ele_name;
159: --
160: CURSOR csr_get_bal_info (c_bal_name VARCHAR2) IS

Line 169: FROM pay_shadow_element_types

165: AND balance_name = c_bal_name;
166: --
167: CURSOR csr_shd_ele (c_shd_elename VARCHAR2) IS
168: SELECT element_type_id, object_version_NUMBER
169: FROM pay_shadow_element_types
170: WHERE template_id = l_template_id
171: AND element_name = c_shd_elename;
172: --
173: CURSOR csr_ipv (c_ele_typeid NUMBER