APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 111: l_template_id pay_shadow_element_types.template_id%TYPE;

107: p_validate (B) - TRUE or FALSE
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;

Line 246: FROM pay_shadow_element_types

242: -- Cursor to retrieve the shadow element information
243: CURSOR csr_get_shadow_ele_info (c_ele_name VARCHAR2)
244: IS
245: SELECT element_type_id, object_version_number
246: FROM pay_shadow_element_types
247: WHERE template_id = l_template_id AND element_name = c_ele_name;
248:
249: -- Cursor to retrieve the shadow balance information
250: CURSOR csr_get_shadow_bal_info (c_bal_name VARCHAR2)

Line 718: FROM pay_shadow_element_types

714: --
715: CURSOR csr_get_prs_priority
716: IS
717: SELECT relative_processing_priority
718: FROM pay_shadow_element_types
719: WHERE element_type_id = p_element_type_id;
720:
721: l_proc_name VARCHAR2 (80)
722: := g_proc_name