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.PQP_NL_PGGM_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 115: (element_type_id pay_shadow_element_types.element_type_id%TYPE

111: )
112: RETURN NUMBER IS
113: --
114: TYPE shadow_ele_rec IS RECORD
115: (element_type_id pay_shadow_element_types.element_type_id%TYPE
116: ,object_version_number
117: pay_shadow_element_types.object_version_NUMBER%TYPE
118: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
119: ,description pay_shadow_element_types.description%TYPE

Line 117: pay_shadow_element_types.object_version_NUMBER%TYPE

113: --
114: TYPE shadow_ele_rec IS RECORD
115: (element_type_id pay_shadow_element_types.element_type_id%TYPE
116: ,object_version_number
117: pay_shadow_element_types.object_version_NUMBER%TYPE
118: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
119: ,description pay_shadow_element_types.description%TYPE
120: );
121: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec

Line 118: ,reporting_name pay_shadow_element_types.reporting_name%TYPE

114: TYPE shadow_ele_rec IS RECORD
115: (element_type_id pay_shadow_element_types.element_type_id%TYPE
116: ,object_version_number
117: pay_shadow_element_types.object_version_NUMBER%TYPE
118: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
119: ,description pay_shadow_element_types.description%TYPE
120: );
121: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec
122: INDEX BY BINARY_INTEGER;

Line 119: ,description pay_shadow_element_types.description%TYPE

115: (element_type_id pay_shadow_element_types.element_type_id%TYPE
116: ,object_version_number
117: pay_shadow_element_types.object_version_NUMBER%TYPE
118: ,reporting_name pay_shadow_element_types.reporting_name%TYPE
119: ,description pay_shadow_element_types.description%TYPE
120: );
121: TYPE t_shadow_ele_info IS TABLE OF shadow_ele_rec
122: INDEX BY BINARY_INTEGER;
123:

Line 204: l_template_id pay_shadow_element_types.template_id%TYPE;

200: l_abs_text VARCHAR2(32767);
201: l_dbi_user_name ff_database_items.user_name%TYPE;
202: l_balance_name pay_balance_types.balance_name%TYPE;
203: l_balance_dbi_name ff_database_items.user_name%TYPE;
204: l_template_id pay_shadow_element_types.template_id%TYPE;
205: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
206: l_er_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
207: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;

Line 259: FROM pay_shadow_element_types

255: --
256: CURSOR csr_get_ele_info (c_ele_name VARCHAR2) IS
257: SELECT element_type_id
258: ,object_version_NUMBER
259: FROM pay_shadow_element_types
260: WHERE template_id = l_template_id
261: AND element_name = c_ele_name;
262: --
263: CURSOR csr_get_bal_info (c_bal_name VARCHAR2) IS

Line 272: FROM pay_shadow_element_types

268: AND balance_name = c_bal_name;
269: --
270: CURSOR csr_shd_ele (c_shd_elename VARCHAR2) IS
271: SELECT element_type_id, object_version_NUMBER
272: FROM pay_shadow_element_types
273: WHERE template_id = l_template_id
274: AND element_name = c_shd_elename;
275: --
276: CURSOR csr_ipv (c_ele_typeid NUMBER