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_PENSION_SCHEME_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 116: l_object_version_number pay_element_types_f.object_version_number%TYPE;

112: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
113: l_base_fwc_element_type_id pay_template_core_objects.core_object_id%TYPE;
114: l_base_fwc_element_type_id_fix pay_template_core_objects.core_object_id%TYPE;
115: l_source_template_id pay_element_templates.template_id%TYPE;
116: l_object_version_number pay_element_types_f.object_version_number%TYPE;
117: l_proc_name VARCHAR2 (80)
118: := g_proc_name
119: || 'create_user_template_low';
120: l_element_type_id NUMBER;

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

129: l_eei_info_id NUMBER;
130: l_ovn_eei NUMBER;
131: l_exists VARCHAR2 (1);
132:
133: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
134: INDEX BY BINARY_INTEGER;
135:
136: l_ele_name t_ele_name;
137: l_ele_new_name t_ele_name;

Line 176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;

172: l_exc_fsavc_eer_rule_id VARCHAR2 (1);
173: l_cont_iv_name pay_input_values_f.NAME%TYPE;
174: l_skip_formula ff_formulas_f.formula_name%TYPE;
175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;
180: l_sub_class_name pay_element_classifications.classification_name%TYPE;

Line 177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;

173: l_cont_iv_name pay_input_values_f.NAME%TYPE;
174: l_skip_formula ff_formulas_f.formula_name%TYPE;
175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;
180: l_sub_class_name pay_element_classifications.classification_name%TYPE;
181: l_pensionable_sal_bal_id NUMBER;

Line 178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;

174: l_skip_formula ff_formulas_f.formula_name%TYPE;
175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;
180: l_sub_class_name pay_element_classifications.classification_name%TYPE;
181: l_pensionable_sal_bal_id NUMBER;
182: l_pensionable_sal_bal_name pay_balance_types.balance_name%TYPE;

Line 330: FROM pay_element_types_f

326: --
327: CURSOR csr_get_ele_id
328: IS
329: SELECT element_type_id
330: FROM pay_element_types_f
331: WHERE element_name = p_object_name
332: AND business_group_id = p_business_group_id
333: AND p_effective_start_date BETWEEN effective_start_date
334: AND effective_end_date;

Line 406: FROM pay_input_values_f piv, pay_element_types_f pet

402: IS
403: CURSOR csr_getinput (c_ele_name VARCHAR2, c_iv_name VARCHAR2)
404: IS
405: SELECT piv.input_value_id, piv.NAME, piv.element_type_id
406: FROM pay_input_values_f piv, pay_element_types_f pet
407: WHERE element_name = c_ele_name
408: AND piv.element_type_id = pet.element_type_id
409: AND piv.business_group_id = p_business_group_id
410: AND piv.NAME = c_iv_name;

Line 877: FROM pay_element_type_extra_info eeit, pay_element_types_f pet

873:
874: CURSOR csr_chk_ocp_ele_info (c_element_type_id NUMBER)
875: IS
876: SELECT 'X'
877: FROM pay_element_type_extra_info eeit, pay_element_types_f pet
878: WHERE pet.element_type_id = c_element_type_id
879: AND ( ( pet.business_group_id IS NOT NULL
880: AND pet.business_group_id = p_business_group_id
881: )

Line 3423: ,pay_element_types_f pet

3419: SELECT 'X'
3420: FROM DUAL
3421: WHERE EXISTS ( SELECT 1
3422: FROM pay_element_type_extra_info eei
3423: ,pay_element_types_f pet
3424: WHERE pet.element_type_id = eei.element_type_id
3425: AND pet.business_group_id =
3426: p_business_group_id
3427: AND eei.information_type =

Line 3893: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3889: || 'delete_user_template';
3890: l_eei_info_id NUMBER;
3891: l_ovn_eei NUMBER;
3892: l_exists VARCHAR2 (1);
3893: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3894:
3895: -- Cursor to get template id
3896: CURSOR csr_get_template_id
3897: IS

Line 3910: FROM pay_template_core_objects pet, pay_element_types_f petf

3906: -- template
3907: CURSOR csr_get_ele_type_id (c_template_id NUMBER)
3908: IS
3909: SELECT element_type_id
3910: FROM pay_template_core_objects pet, pay_element_types_f petf
3911: WHERE pet.template_id = c_template_id
3912: AND petf.element_type_id = pet.core_object_id
3913: AND pet.core_object_type = 'ET';
3914: