APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 271: l_template_id pay_shadow_element_types.template_id%type;

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

Line 298: (element_type_id pay_shadow_element_types.element_type_id%type

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

Line 299: ,object_version_number pay_shadow_element_types.object_version_number%type

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

Line 300: ,reporting_name pay_shadow_element_types.reporting_name%type

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

Line 301: ,description pay_shadow_element_types.description%type

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

Line 375: from pay_shadow_element_types

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

Line 388: from pay_shadow_element_types

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