APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_BALANCE_DIMENSIONS

Line 68: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;

64: l_bl_core_id pay_balance_types.balance_type_id%TYPE;
65: l_bf_pbdbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
66: l_db_core_id pay_defined_balances.defined_balance_id%TYPE;
67: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
68: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
69:
70: -- Extra Information variables
71: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
72: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;

Line 192: FROM pay_balance_dimensions

188: IS
189:
190: CURSOR csr_id_baldmn IS
191: SELECT balance_dimension_id
192: FROM pay_balance_dimensions
193: WHERE dimension_name = p_dimension_name
194: AND ((business_group_id is null and legislation_code is null)
195: OR
196: (legislation_code is null and business_group_id + 0 =

Line 201: l_bd_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;

197: p_bg_id)
198: OR
199: (business_group_id is null and legislation_code = 'GB'));
200:
201: l_bd_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
202: l_proc varchar2(80) := 'pqp_gb_professional_body_temp.get_balance_dimension_id';
203:
204: BEGIN
205: