DBA Data[Home] [Help]

APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 877: FROM pay_shadow_balance_types

873:
874: CURSOR csr_get_bal_info (c_bal_name varchar2) is
875: SELECT balance_type_id
876: ,object_version_number
877: FROM pay_shadow_balance_types
878: WHERE template_id = l_template_id
879: AND balance_name = c_bal_name;
880:
881: CURSOR csr_chk_primary_exists is

Line 954: FROM pay_shadow_balance_types psbt,

950: AND business_group_id = p_bg_id;
951: --
952: CURSOR c3 (c_object_name in varchar2) is
953: SELECT ptco.core_object_id
954: FROM pay_shadow_balance_types psbt,
955: pay_template_core_objects ptco
956: WHERE psbt.template_id = l_template_id
957: AND psbt.balance_name = c_object_name
958: AND ptco.template_id = psbt.template_id