eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 36: (element_type_id pay_shadow_element_types.element_type_id%TYPE

32: )
33: RETURN NUMBER IS
34: --
35: TYPE shadow_ele_rec IS RECORD
36: (element_type_id pay_shadow_element_types.element_type_id%TYPE
37: ,object_version_number
38: pay_shadow_element_types.object_version_NUMBER%TYPE
39: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
40: ,description pay_shadow_element_types.description%TYPE

Line 38: pay_shadow_element_types.object_version_NUMBER%TYPE

34: --
35: TYPE shadow_ele_rec IS RECORD
36: (element_type_id pay_shadow_element_types.element_type_id%TYPE
37: ,object_version_number
38: pay_shadow_element_types.object_version_NUMBER%TYPE
39: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
40: ,description pay_shadow_element_types.description%TYPE
41: );
42: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec

Line 39: ,reporting_name pay_shadow_element_types.reporting_name%TYPE

35: TYPE shadow_ele_rec IS RECORD
36: (element_type_id pay_shadow_element_types.element_type_id%TYPE
37: ,object_version_number
38: pay_shadow_element_types.object_version_NUMBER%TYPE
39: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
40: ,description pay_shadow_element_types.description%TYPE
41: );
42: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec
43: INDEX BY BINARY_INTEGER;

Line 40: ,description pay_shadow_element_types.description%TYPE

36: (element_type_id pay_shadow_element_types.element_type_id%TYPE
37: ,object_version_number
38: pay_shadow_element_types.object_version_NUMBER%TYPE
39: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
40: ,description pay_shadow_element_types.description%TYPE
41: );
42: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec
43: INDEX BY BINARY_INTEGER;
44:

Line 133: l_template_id pay_shadow_element_types.template_id%TYPE;

129: l_abs_text VARCHAR2(32767);
130: l_dbi_user_name ff_database_items.user_name%TYPE;
131: l_balance_name pay_balance_types.balance_name%TYPE;
132: l_balance_dbi_name ff_database_items.user_name%TYPE;
133: l_template_id pay_shadow_element_types.template_id%TYPE;
134: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
135: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
136: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
137: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 199: FROM pay_shadow_element_types

195: --
196: CURSOR csr_get_ele_info (c_ele_name VARCHAR2) IS
197: SELECT element_type_id
198: ,object_version_NUMBER
199: FROM pay_shadow_element_types
200: WHERE template_id = l_template_id
201: AND element_name = c_ele_name;
202: --
203: CURSOR csr_get_bal_info (c_bal_name VARCHAR2) IS

Line 212: FROM pay_shadow_element_types

208: AND balance_name = c_bal_name;
209: --
210: CURSOR csr_shd_ele (c_shd_elename VARCHAR2) IS
211: SELECT element_type_id, object_version_NUMBER
212: FROM pay_shadow_element_types
213: WHERE template_id = l_template_id
214: AND element_name = c_shd_elename;
215: --
216: CURSOR csr_ipv (c_ele_typeid NUMBER