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

Line 454: l_template_id pay_shadow_element_types.template_id%type;

450: ,p_business_group_id In Number
451: )
452: return Number is
453: --
454: l_template_id pay_shadow_element_types.template_id%type;
455: l_base_element_type_id pay_template_core_objects.core_object_id%type;
456: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
457: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
458: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;

Line 493: (element_type_id pay_shadow_element_types.element_type_id%type

489: l_bal_name4 varchar2(80);
490: l_configuration_information1 Varchar2(10) := 'N';
491:
492: type shadow_ele_rec is record
493: (element_type_id pay_shadow_element_types.element_type_id%type
494: ,object_version_number pay_shadow_element_types.object_version_number%type
495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type

Line 494: ,object_version_number pay_shadow_element_types.object_version_number%type

490: l_configuration_information1 Varchar2(10) := 'N';
491:
492: type shadow_ele_rec is record
493: (element_type_id pay_shadow_element_types.element_type_id%type
494: ,object_version_number pay_shadow_element_types.object_version_number%type
495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type
498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type

Line 495: ,reporting_name pay_shadow_element_types.reporting_name%type

491:
492: type shadow_ele_rec is record
493: (element_type_id pay_shadow_element_types.element_type_id%type
494: ,object_version_number pay_shadow_element_types.object_version_number%type
495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type
498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
499: ,classification_name pay_shadow_element_types.classification_name%type

Line 496: ,description pay_shadow_element_types.description%type

492: type shadow_ele_rec is record
493: (element_type_id pay_shadow_element_types.element_type_id%type
494: ,object_version_number pay_shadow_element_types.object_version_number%type
495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type
498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
499: ,classification_name pay_shadow_element_types.classification_name%type
500: );

Line 497: ,priority pay_shadow_element_types.relative_processing_priority%type

493: (element_type_id pay_shadow_element_types.element_type_id%type
494: ,object_version_number pay_shadow_element_types.object_version_number%type
495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type
498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
499: ,classification_name pay_shadow_element_types.classification_name%type
500: );
501: type t_shadow_ele_info is table of shadow_ele_rec

Line 498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type

494: ,object_version_number pay_shadow_element_types.object_version_number%type
495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type
498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
499: ,classification_name pay_shadow_element_types.classification_name%type
500: );
501: type t_shadow_ele_info is table of shadow_ele_rec
502: index by Binary_Integer;

Line 499: ,classification_name pay_shadow_element_types.classification_name%type

495: ,reporting_name pay_shadow_element_types.reporting_name%type
496: ,description pay_shadow_element_types.description%type
497: ,priority pay_shadow_element_types.relative_processing_priority%type
498: ,third_party_pay_only_flag pay_shadow_element_types.third_party_pay_only_flag%type
499: ,classification_name pay_shadow_element_types.classification_name%type
500: );
501: type t_shadow_ele_info is table of shadow_ele_rec
502: index by Binary_Integer;
503: l_shadow_element t_shadow_ele_info;

Line 567: from pay_shadow_element_types

563:
564: cursor csr_get_ele_info (c_ele_name varchar2) is
565: select element_type_id
566: ,object_version_number
567: from pay_shadow_element_types
568: where template_id = l_template_id
569: and element_name = c_ele_name;
570: --
571: cursor csr_get_bal_info (c_bal_name varchar2) is

Line 580: from pay_shadow_element_types

576: and balance_name = c_bal_name;
577: --
578: cursor csr_shd_ele (c_shd_elename varchar2) is
579: select element_type_id, object_version_number, relative_processing_priority, third_party_pay_only_flag, classification_name
580: from pay_shadow_element_types
581: where template_id = l_template_id
582: and element_name = c_shd_elename;
583: --
584: cursor csr_ipv (c_ele_typeid number