APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 84: l_bl_unnbal_nm pay_shadow_balance_types.balance_name%TYPE;

80:
81:
82:
83:
84: l_bl_unnbal_nm pay_shadow_balance_types.balance_name%TYPE;
85: l_bf_unnbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
86:
87: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;

Line 344: FROM pay_shadow_balance_types psbt,

340: AND business_group_id = p_frm_business_group_id;
341: --
342: CURSOR csr_bl_coreobj(p_xx_object_nm VARCHAR2) IS
343: SELECT ptco.core_object_id
344: FROM pay_shadow_balance_types psbt,
345: pay_template_core_objects ptco
346: WHERE psbt.template_id = l_te_usrstr_id
347: AND psbt.balance_name = p_xx_object_nm
348: AND ptco.template_id = psbt.template_id