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_TEMPLATE_CORE_OBJECTS

Line 112: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

108:
109: -----------------------------------------------------------------------------*/
110: --
111: l_template_id pay_shadow_element_types.template_id%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;

Line 113: l_base_fwc_element_type_id pay_template_core_objects.core_object_id%TYPE;

109: -----------------------------------------------------------------------------*/
110: --
111: l_template_id pay_shadow_element_types.template_id%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)

Line 114: l_base_fwc_element_type_id_fix pay_template_core_objects.core_object_id%TYPE;

110: --
111: l_template_id pay_shadow_element_types.template_id%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

Line 341: ,pay_template_core_objects ptco

337: CURSOR csr_get_bal_id
338: IS
339: SELECT ptco.core_object_id
340: FROM pay_shadow_balance_types psbt
341: ,pay_template_core_objects ptco
342: WHERE psbt.template_id = l_template_id
343: AND psbt.balance_name = p_object_name
344: AND ptco.template_id = psbt.template_id
345: AND ptco.shadow_object_id = psbt.balance_type_id;

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: