DBA Data[Home] [Help]

APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_SHADOW_BALANCE_TYPES

Line 209: FROM pay_shadow_balance_types

205:
206: CURSOR csr_get_bal_info (c_bal_name varchar2) is
207: SELECT balance_type_id
208: ,object_version_number
209: FROM pay_shadow_balance_types
210: WHERE template_id = l_template_id
211: AND balance_name = c_bal_name;
212:
213: CURSOR c_get_band_meaning (c_effective_date DATE) IS

Line 291: FROM pay_shadow_balance_types psbt,

287: AND business_group_id = p_bg_id;
288: --
289: CURSOR c3 (c_object_name in varchar2) is
290: SELECT ptco.core_object_id
291: FROM pay_shadow_balance_types psbt,
292: pay_template_core_objects ptco
293: WHERE psbt.template_id = l_template_id
294: AND psbt.balance_name = c_object_name
295: AND ptco.template_id = psbt.template_id