DBA Data[Home] [Help]

APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 215: FROM pay_shadow_balance_types psbt,

211: AND business_group_id = p_business_group_id;
212: --
213: CURSOR c3 (c_object_name in varchar2) is
214: SELECT ptco.core_object_id
215: FROM pay_shadow_balance_types psbt,
216: pay_template_core_objects ptco
217: WHERE psbt.template_id = p_template_id
218: AND psbt.balance_name = c_object_name
219: AND ptco.template_id = psbt.template_id

Line 955: FROM pay_shadow_balance_types

951:
952: CURSOR csr_get_bal_info (c_bal_name varchar2) is
953: SELECT balance_type_id
954: ,object_version_number
955: FROM pay_shadow_balance_types
956: WHERE template_id = l_template_id
957: AND balance_name = c_bal_name;
958:
959: CURSOR csr_chk_primary_exists is