DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 122: from pay_shadow_balance_types psbt,

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

Line 382: from pay_shadow_balance_types

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