APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 318: l_template_id pay_shadow_element_types.template_id%type;

314: ,p_business_group_id in Number
315: )
316: return Number is
317: --
318: l_template_id pay_shadow_element_types.template_id%type;
319: l_base_element_type_id pay_template_core_objects.core_object_id%type;
320: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
321: l_source_template_id pay_element_templates.template_id%type;
322: l_object_version_number pay_element_types_f.object_version_number%type;

Line 347: (element_type_id pay_shadow_element_types.element_type_id%type

343: l_deduction_method varchar2(4) := p_deduction_method;
344: l_zvw_text VARCHAR2(5000):= ' ' ;
345:
346: type shadow_ele_rec is record
347: (element_type_id pay_shadow_element_types.element_type_id%type
348: ,object_version_number pay_shadow_element_types.object_version_number%type
349: ,reporting_name pay_shadow_element_types.reporting_name%type
350: ,description pay_shadow_element_types.description%type
351: );

Line 348: ,object_version_number pay_shadow_element_types.object_version_number%type

344: l_zvw_text VARCHAR2(5000):= ' ' ;
345:
346: type shadow_ele_rec is record
347: (element_type_id pay_shadow_element_types.element_type_id%type
348: ,object_version_number pay_shadow_element_types.object_version_number%type
349: ,reporting_name pay_shadow_element_types.reporting_name%type
350: ,description pay_shadow_element_types.description%type
351: );
352: type t_shadow_ele_info is table of shadow_ele_rec

Line 349: ,reporting_name pay_shadow_element_types.reporting_name%type

345:
346: type shadow_ele_rec is record
347: (element_type_id pay_shadow_element_types.element_type_id%type
348: ,object_version_number pay_shadow_element_types.object_version_number%type
349: ,reporting_name pay_shadow_element_types.reporting_name%type
350: ,description pay_shadow_element_types.description%type
351: );
352: type t_shadow_ele_info is table of shadow_ele_rec
353: index by Binary_Integer;

Line 350: ,description pay_shadow_element_types.description%type

346: type shadow_ele_rec is record
347: (element_type_id pay_shadow_element_types.element_type_id%type
348: ,object_version_number pay_shadow_element_types.object_version_number%type
349: ,reporting_name pay_shadow_element_types.reporting_name%type
350: ,description pay_shadow_element_types.description%type
351: );
352: type t_shadow_ele_info is table of shadow_ele_rec
353: index by Binary_Integer;
354: l_shadow_element t_shadow_ele_info;

Line 422: from pay_shadow_element_types

418: --
419: cursor csr_get_ele_info (c_ele_name varchar2) is
420: select element_type_id
421: ,object_version_number
422: from pay_shadow_element_types
423: where template_id = l_template_id
424: and element_name = c_ele_name;
425: --
426: cursor csr_get_bal_info (c_bal_name varchar2) is

Line 435: from pay_shadow_element_types

431: and balance_name = c_bal_name;
432: --
433: cursor csr_shd_ele (c_shd_elename varchar2) is
434: select element_type_id, object_version_number
435: from pay_shadow_element_types
436: where template_id = l_template_id
437: and element_name = c_shd_elename;
438: --
439: cursor csr_ipv (c_ele_typeid number

Line 454: from pay_shadow_element_types

450: select input_value_id
451: from pay_shadow_input_values
452: where element_type_id =
453: (Select element_type_id
454: from pay_shadow_element_types
455: where template_id = l_template_id
456: and element_name = c_shd_elename)
457: and name = 'Percentage';
458: --