APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_BALANCE_TYPES

Line 48: on pay_balance_types for all

44: element.
45: 17-FEB-2000 RThirlby Added new procedure
46: update_jd_level_on_balance.
47: This updates jurisdiction_level
48: on pay_balance_types for all
49: balances.
50: Changes for Flexi date too.
51: 29-FEB-2000 RThirlby Added p_ele_eoy_type to
52: procedure create_user_init_

Line 399: from pay_balance_types

395: --
396: BEGIN
397: select 'Y'
398: into l_installed
399: from pay_balance_types
400: where upper(balance_name) = 'FED SUBJECT'
401: and legislation_code = 'CA';
402:
403: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 443: from pay_balance_types

439: --
440: BEGIN
441: select 'Y'
442: into l_reserved
443: from pay_balance_types
444: where upper(p_ele_name) = upper(balance_name)
445: and nvl(legislation_code, 'CA') = 'CA'
446: and nvl(business_group_id, p_bg_id) = p_bg_id;
447:

Line 1067: from pay_balance_types

1063:
1064:
1065: select balance_type_id
1066: into l_balance_type_id
1067: from pay_balance_types
1068: where balance_name = 'Taxable Benefits for Quebec';
1069:
1070: pay_balance_feeds_f_pkg.insert_row (l_balance_row_id,
1071: l_balance_feed_id,

Line 1179: UPDATE pay_balance_types

1175: BEGIN
1176: --
1177: FOR each_balance in get_balance_type_ids(p_template_id) LOOP
1178: --
1179: UPDATE pay_balance_types
1180: SET jurisdiction_level = 2
1181: WHERE balance_type_id = each_balance.core_object_id;
1182: --
1183: END LOOP;