APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 66: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;

62: p_bg_id (N) - Business group id
63: ----------------------------------------------------------------------*/
64: --
65: l_template_id pay_shadow_element_types.template_id%TYPE;
66: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
67: l_source_template_id pay_element_templates.template_id%TYPE;
68: l_object_version_number NUMBER(9);
69: l_proc VARCHAR2(80) :=
70: 'pqp_gb_pensions_template.create_user_template';

Line 132: pay_template_core_objects ptco

128: --
129: CURSOR c5 (c_element_name in varchar2) is
130: SELECT ptco.core_object_id
131: FROM pay_shadow_element_types psbt,
132: pay_template_core_objects ptco
133: WHERE psbt.template_id = l_template_id
134: AND psbt.element_name = c_element_name
135: AND ptco.template_id = psbt.template_id
136: AND ptco.shadow_object_id = psbt.element_type_id

Line 320: pay_template_core_objects ptco

316: --
317: CURSOR c3 (c_object_name in varchar2) is
318: SELECT ptco.core_object_id
319: FROM pay_shadow_balance_types psbt,
320: pay_template_core_objects ptco
321: WHERE psbt.template_id = l_template_id
322: AND psbt.balance_name = c_object_name
323: AND ptco.template_id = psbt.template_id
324: AND ptco.shadow_object_id = psbt.balance_type_id;