DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 120: from pay_shadow_balance_types psbt,

116: and business_group_id = p_business_group_id;
117: --
118: cursor c3 (c_object_name in Varchar2) is
119: select ptco.core_object_id
120: from pay_shadow_balance_types psbt,
121: pay_template_core_objects ptco
122: where psbt.template_id = p_template_id
123: and psbt.balance_name = c_object_name
124: and ptco.template_id = psbt.template_id

Line 380: from pay_shadow_balance_types

376: --
377: cursor csr_get_bal_info (c_bal_name varchar2) is
378: select balance_type_id
379: ,object_version_number
380: from pay_shadow_balance_types
381: where template_id = l_template_id
382: and balance_name = c_bal_name;
383: --
384: cursor csr_shd_ele (c_shd_elename varchar2) is