APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 269: l_template_id pay_shadow_element_types.template_id%type;

265: ,p_business_group_id in Number
266: )
267: return Number is
268: --
269: l_template_id pay_shadow_element_types.template_id%type;
270: l_base_element_type_id pay_template_core_objects.core_object_id%type;
271: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
272: l_source_template_id pay_element_templates.template_id%type;
273: l_object_version_number pay_element_types_f.object_version_number%type;

Line 296: (element_type_id pay_shadow_element_types.element_type_id%type

292: l_std_link_flag varchar2(10) := 'N';
293: l_scheme_prefix varchar2(50) := p_scheme_prefix;
294:
295: type shadow_ele_rec is record
296: (element_type_id pay_shadow_element_types.element_type_id%type
297: ,object_version_number pay_shadow_element_types.object_version_number%type
298: ,reporting_name pay_shadow_element_types.reporting_name%type
299: ,description pay_shadow_element_types.description%type
300: );

Line 297: ,object_version_number pay_shadow_element_types.object_version_number%type

293: l_scheme_prefix varchar2(50) := p_scheme_prefix;
294:
295: type shadow_ele_rec is record
296: (element_type_id pay_shadow_element_types.element_type_id%type
297: ,object_version_number pay_shadow_element_types.object_version_number%type
298: ,reporting_name pay_shadow_element_types.reporting_name%type
299: ,description pay_shadow_element_types.description%type
300: );
301: type t_shadow_ele_info is table of shadow_ele_rec

Line 298: ,reporting_name pay_shadow_element_types.reporting_name%type

294:
295: type shadow_ele_rec is record
296: (element_type_id pay_shadow_element_types.element_type_id%type
297: ,object_version_number pay_shadow_element_types.object_version_number%type
298: ,reporting_name pay_shadow_element_types.reporting_name%type
299: ,description pay_shadow_element_types.description%type
300: );
301: type t_shadow_ele_info is table of shadow_ele_rec
302: index by Binary_Integer;

Line 299: ,description pay_shadow_element_types.description%type

295: type shadow_ele_rec is record
296: (element_type_id pay_shadow_element_types.element_type_id%type
297: ,object_version_number pay_shadow_element_types.object_version_number%type
298: ,reporting_name pay_shadow_element_types.reporting_name%type
299: ,description pay_shadow_element_types.description%type
300: );
301: type t_shadow_ele_info is table of shadow_ele_rec
302: index by Binary_Integer;
303: l_shadow_element t_shadow_ele_info;

Line 373: from pay_shadow_element_types

369: --
370: cursor csr_get_ele_info (c_ele_name varchar2) is
371: select element_type_id
372: ,object_version_number
373: from pay_shadow_element_types
374: where template_id = l_template_id
375: and element_name = c_ele_name;
376: --
377: cursor csr_get_bal_info (c_bal_name varchar2) is

Line 386: from pay_shadow_element_types

382: and balance_name = c_bal_name;
383: --
384: cursor csr_shd_ele (c_shd_elename varchar2) is
385: select element_type_id, object_version_number
386: from pay_shadow_element_types
387: where template_id = l_template_id
388: and element_name = c_shd_elename;
389: --
390: cursor csr_ipv (c_ele_typeid number