DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 253: FROM pay_shadow_balance_types

249: -- Cursor to retrieve the shadow balance information
250: CURSOR csr_get_shadow_bal_info (c_bal_name VARCHAR2)
251: IS
252: SELECT balance_type_id, object_version_number
253: FROM pay_shadow_balance_types
254: WHERE template_id = l_template_id AND balance_name = c_bal_name;
255:
256: -- Cursor to check unique base name
257: CURSOR csr_chk_uniq_base_name

Line 340: FROM pay_shadow_balance_types psbt

336: --
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