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 404: from pay_balance_types

400: --
401: BEGIN
402: select 'Y'
403: into l_installed
404: from pay_balance_types
405: where upper(balance_name) = 'FED SUBJECT'
406: and legislation_code = 'CA';
407:
408: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 448: from pay_balance_types

444: --
445: BEGIN
446: select 'Y'
447: into l_reserved
448: from pay_balance_types
449: where upper(p_ele_name) = upper(balance_name)
450: and nvl(legislation_code, 'CA') = 'CA'
451: and nvl(business_group_id, p_bg_id) = p_bg_id;
452:

Line 1075: from pay_balance_types

1071:
1072:
1073: select balance_type_id
1074: into l_balance_type_id
1075: from pay_balance_types
1076: where balance_name = 'Taxable Benefits for Quebec';
1077:
1078: pay_balance_feeds_f_pkg.insert_row (l_balance_row_id,
1079: l_balance_feed_id,

Line 1187: UPDATE pay_balance_types

1183: BEGIN
1184: --
1185: FOR each_balance in get_balance_type_ids(p_template_id) LOOP
1186: --
1187: UPDATE pay_balance_types
1188: SET jurisdiction_level = 2
1189: WHERE balance_type_id = each_balance.core_object_id;
1190: --
1191: END LOOP;