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.PQP_GB_OSP_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 708: l_object_version_number pay_element_types_f.object_version_number%TYPE;

704:
705: l_template_id pay_shadow_element_types.template_id%TYPE;
706: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
707: l_source_template_id pay_element_templates.template_id%TYPE;
708: l_object_version_number pay_element_types_f.object_version_number%TYPE;
709:
710: l_proc_step NUMBER(20,10);
711: l_proc_name VARCHAR2(80) :=
712: g_package_name || 'create_user_template';

Line 739: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE

735: l_template_name pay_element_templates.template_name%TYPE ;
736: l_configuration_information2 pay_element_templates.configuration_information2%TYPE;
737:
738:
739: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
740: INDEX BY BINARY_INTEGER;
741:
742: l_ele_name t_ele_name;
743: l_ele_new_name t_ele_name;

Line 754: TYPE t_ele_reporting_name IS TABLE OF pay_element_types_f.reporting_name%TYPE

750: l_bal_name t_bal_name;
751: l_bal_new_name t_bal_name;
752:
753:
754: TYPE t_ele_reporting_name IS TABLE OF pay_element_types_f.reporting_name%TYPE
755: INDEX BY BINARY_INTEGER;
756:
757: l_ele_reporting_name t_ele_reporting_name;
758:

Line 759: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE

755: INDEX BY BINARY_INTEGER;
756:
757: l_ele_reporting_name t_ele_reporting_name;
758:
759: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE
760: INDEX BY BINARY_INTEGER;
761:
762: l_ele_description t_ele_description;
763:

Line 764: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE

760: INDEX BY BINARY_INTEGER;
761:
762: l_ele_description t_ele_description;
763:
764: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE
765: INDEX BY BINARY_INTEGER;
766:
767: l_ele_pp t_ele_pp;
768:

Line 948: FROM pay_element_types_f

944: l_proc_name varchar2(72) := g_package_name || 'get_object_id';
945: --
946: CURSOR c2 (c_object_name varchar2) is
947: SELECT element_type_id
948: FROM pay_element_types_f
949: WHERE element_name = c_object_name
950: AND business_group_id = p_bg_id;
951: --
952: CURSOR c3 (c_object_name in varchar2) is

Line 990: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;

986: ,p_retro_ele_name in varchar2
987: ) IS
988: --
989:
990: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;
991: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;
992: l_proc_step NUMBER(20,10);
993: l_proc_name VARCHAR2(72) := g_package_name ||
994: 'update_ele_retro_info';

Line 991: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;

987: ) IS
988: --
989:
990: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;
991: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;
992: l_proc_step NUMBER(20,10);
993: l_proc_name VARCHAR2(72) := g_package_name ||
994: 'update_ele_retro_info';
995:

Line 1027: UPDATE pay_element_types_f

1023: debug(l_proc_name, l_proc_step);
1024: END IF;
1025:
1026:
1027: UPDATE pay_element_types_f
1028: SET retro_summ_ele_id = l_retro_ele_type_id
1029: WHERE element_type_id = l_main_ele_type_id;
1030:
1031: --

Line 1095: ,pay_element_types_f pet

1091: SELECT input_value_id
1092: ,piv.name
1093: ,piv.element_type_id
1094: FROM pay_input_values_f piv
1095: ,pay_element_types_f pet
1096: WHERE element_name = c_ele_name
1097: AND piv.element_type_id = pet.element_type_id
1098: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)
1099: AND piv.name = c_iv_name

Line 3241: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;
3238:
3239: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3240: l_exists VARCHAR2(1);
3241: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3242:
3243: TYPE t_number IS TABLE OF NUMBER
3244: INDEX BY BINARY_INTEGER;
3245:

Line 3272: ,pay_element_types_f petf

3268: CURSOR csr_get_ele_type_id (c_template_id number)
3269: IS
3270: SELECT element_type_id
3271: FROM pay_template_core_objects pet
3272: ,pay_element_types_f petf
3273: WHERE pet.template_id = c_template_id
3274: AND petf.element_type_id = pet.core_object_id
3275: AND pet.core_object_type = 'ET';
3276:

Line 3384: -- There is no effective date check on table pay_element_types_f

3380: IS
3381:
3382: -- The original query is split into 2 queries
3383: -- to avoid Merge joins and make use of Indexes.
3384: -- There is no effective date check on table pay_element_types_f
3385: -- as we are interested in data irrespective of date.
3386: -- Cursor to retrieve lookup type information
3387:
3388: CURSOR csr_get_lookup_type(c_base_name in varchar2)

Line 3392: ,pay_element_types_f petf

3388: CURSOR csr_get_lookup_type(c_base_name in varchar2)
3389: IS
3390: SELECT DISTINCT(pete.eei_information18) lookup_type
3391: FROM pay_element_type_extra_info pete
3392: ,pay_element_types_f petf
3393: -- ,pay_element_templates pet
3394: WHERE pete.element_type_id = petf.element_type_id
3395: AND pete.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3396: AND pete.eei_information16 = 'Y'