DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 138: from pay_shadow_balance_types psbt,

134: and business_group_id = p_business_group_id;
135: --
136: cursor c3 (c_object_name in Varchar2) is
137: select ptco.core_object_id
138: from pay_shadow_balance_types psbt,
139: pay_template_core_objects ptco
140: where psbt.template_id = p_template_id
141: and psbt.balance_name = c_object_name
142: and ptco.template_id = psbt.template_id

Line 574: from pay_shadow_balance_types

570: --
571: cursor csr_get_bal_info (c_bal_name varchar2) is
572: select balance_type_id
573: ,object_version_number
574: from pay_shadow_balance_types
575: where template_id = l_template_id
576: and balance_name = c_bal_name;
577: --
578: cursor csr_shd_ele (c_shd_elename varchar2) is