DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 445: l_template_id pay_shadow_element_types.template_id%type;

441: ,p_business_group_id In Number
442: )
443: return Number is
444: --
445: l_template_id pay_shadow_element_types.template_id%type;
446: l_base_element_type_id pay_template_core_objects.core_object_id%type;
447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;

Line 484: (element_type_id pay_shadow_element_types.element_type_id%type

480: l_bal_name4 varchar2(80);
481: l_configuration_information1 Varchar2(10) := 'N';
482:
483: type shadow_ele_rec is record
484: (element_type_id pay_shadow_element_types.element_type_id%type
485: ,object_version_number pay_shadow_element_types.object_version_number%type
486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type

Line 485: ,object_version_number pay_shadow_element_types.object_version_number%type

481: l_configuration_information1 Varchar2(10) := 'N';
482:
483: type shadow_ele_rec is record
484: (element_type_id pay_shadow_element_types.element_type_id%type
485: ,object_version_number pay_shadow_element_types.object_version_number%type
486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type
489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type

Line 486: ,reporting_name pay_shadow_element_types.reporting_name%type

482:
483: type shadow_ele_rec is record
484: (element_type_id pay_shadow_element_types.element_type_id%type
485: ,object_version_number pay_shadow_element_types.object_version_number%type
486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type
489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
490: ,classification_name pay_shadow_element_types.classification_name%type

Line 487: ,description pay_shadow_element_types.description%type

483: type shadow_ele_rec is record
484: (element_type_id pay_shadow_element_types.element_type_id%type
485: ,object_version_number pay_shadow_element_types.object_version_number%type
486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type
489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
490: ,classification_name pay_shadow_element_types.classification_name%type
491: );

Line 488: ,priority pay_shadow_element_types.relative_processing_priority%type

484: (element_type_id pay_shadow_element_types.element_type_id%type
485: ,object_version_number pay_shadow_element_types.object_version_number%type
486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type
489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
490: ,classification_name pay_shadow_element_types.classification_name%type
491: );
492: type t_shadow_ele_info is table of shadow_ele_rec

Line 489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type

485: ,object_version_number pay_shadow_element_types.object_version_number%type
486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type
489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
490: ,classification_name pay_shadow_element_types.classification_name%type
491: );
492: type t_shadow_ele_info is table of shadow_ele_rec
493: index by Binary_Integer;

Line 490: ,classification_name pay_shadow_element_types.classification_name%type

486: ,reporting_name pay_shadow_element_types.reporting_name%type
487: ,description pay_shadow_element_types.description%type
488: ,priority pay_shadow_element_types.relative_processing_priority%type
489: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
490: ,classification_name pay_shadow_element_types.classification_name%type
491: );
492: type t_shadow_ele_info is table of shadow_ele_rec
493: index by Binary_Integer;
494: l_shadow_element t_shadow_ele_info;

Line 558: from pay_shadow_element_types

554:
555: cursor csr_get_ele_info (c_ele_name varchar2) is
556: select element_type_id
557: ,object_version_number
558: from pay_shadow_element_types
559: where template_id = l_template_id
560: and element_name = c_ele_name;
561: --
562: cursor csr_get_bal_info (c_bal_name varchar2) is

Line 571: from pay_shadow_element_types

567: and balance_name = c_bal_name;
568: --
569: cursor csr_shd_ele (c_shd_elename varchar2) is
570: select element_type_id, object_version_number, relative_processing_priority, third_party_pay_only_flag, classification_name
571: from pay_shadow_element_types
572: where template_id = l_template_id
573: and element_name = c_shd_elename;
574: --
575: cursor csr_ipv (c_ele_typeid number