eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on PAY_BALANCE_TYPES

Line 64: -- PAY_BALANCE_TYPES.

60: -- installation procedures:
61: -- - FEED_CHECKING_TYPE in
62: -- PAY_BALANCE_DIMENSIONS;
63: -- - JURISDICTION_LEVEL in
64: -- PAY_BALANCE_TYPES.
65: -- 70.18 Rod Fine 23-Nov-1994 - Suppressed index on business_group_id
66: -- 70.19 Rod Fine 27-Mar-1995 - Added tax_type column to
67: -- pay_balance_types table.
68: -- 70.20 Rod Fine 07-Apr-1995 - Changed order in which hr_leg_loc is

Line 67: -- pay_balance_types table.

63: -- - JURISDICTION_LEVEL in
64: -- PAY_BALANCE_TYPES.
65: -- 70.18 Rod Fine 23-Nov-1994 - Suppressed index on business_group_id
66: -- 70.19 Rod Fine 27-Mar-1995 - Added tax_type column to
67: -- pay_balance_types table.
68: -- 70.20 Rod Fine 07-Apr-1995 - Changed order in which hr_leg_loc is
69: -- called, so that the new classn_id is
70: -- updated BEFORE the table is
71: -- transferred.

Line 79: -- identical pay_balance_types wherever

75: -- Also added maintenance of the
76: -- display_sequence column in the user
77: -- rows table.
78: -- 70.22 Rod Fine 03-Jan-96 - #331831 Add NVLs to the check for
79: -- identical pay_balance_types wherever
80: -- values may be null, to prevent flagging
81: -- as different rows which are identical
82: -- but have some null values.
83: -- 70.23 Rod Fine 09-Jan-96 - #331831 Chngd NVL on jurisdiction_level

Line 543: ,pay_balance_types pbt

539: SELECT distinct ao.key_name
540: ,ao.product_name
541: ,ao.key_value
542: FROM hr_s_application_ownerships ao
543: ,pay_balance_types pbt
544: WHERE pbt.legislation_code = 'ZZ'
545: AND ao.key_name = 'BALANCE_TYPE_ID'
546: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
547: AND NOT EXISTS (SELECT null

Line 1484: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_TYPES

1480:
1481: END install_bal_categories;
1482:
1483: --****************************************************************************
1484: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_TYPES
1485: --****************************************************************************
1486:
1487: PROCEDURE install_bal_types (p_phase IN number)
1488: -----------------------------------------------

Line 1621: from pay_balance_types a

1617:
1618:
1619: select distinct null
1620: into l_null_return
1621: from pay_balance_types a
1622: where exists
1623: (select null
1624: from hr_s_balance_types b
1625: where a.balance_type_id = b.balance_type_id

Line 1692: from pay_balance_types;

1688: from hr_s_balance_types;
1689:
1690: select max(balance_type_id)
1691: into v_max_live
1692: from pay_balance_types;
1693:
1694: select pay_balance_types_s.nextval
1695: into v_sequence_number
1696: from dual;

Line 1694: select pay_balance_types_s.nextval

1690: select max(balance_type_id)
1691: into v_max_live
1692: from pay_balance_types;
1693:
1694: select pay_balance_types_s.nextval
1695: into v_sequence_number
1696: from dual;
1697:
1698: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 1703: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1699: OR (v_sequence_number < v_max_live) THEN
1700:
1701: IF v_max_live > v_max_delivered THEN
1702:
1703: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1704: v_sequence_number,
1705: v_max_live);
1706: ELSE
1707:

Line 1708: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1704: v_sequence_number,
1705: v_max_live);
1706: ELSE
1707:
1708: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1709: v_sequence_number,
1710: v_max_delivered);
1711: END IF;
1712: END IF;

Line 1746: insert_hr_stu_exceptions('pay_balance_types'

1742:
1743: BEGIN
1744:
1745: rollback to new_balance_name;
1746: insert_hr_stu_exceptions('pay_balance_types'
1747: , stu_rec.c_surrogate_key
1748: , exception_type
1749: , stu_rec.c_true_key);
1750:

Line 1765: from pay_balance_types

1761: BEGIN
1762:
1763: select distinct balance_type_id
1764: into l_new_surrogate_key
1765: from pay_balance_types
1766: where replace(ltrim(rtrim(upper(balance_name))), ' ', '_') =
1767: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_')
1768: and business_group_id is null
1769: and ( (legislation_code is null and stu_rec.c_leg_code is null)

Line 1777: select pay_balance_types_s.nextval

1773:
1774: EXCEPTION WHEN NO_DATA_FOUND THEN
1775:
1776:
1777: select pay_balance_types_s.nextval
1778: into l_new_surrogate_key
1779: from dual;
1780:
1781: v_new_balance_type_flag := 'Y';

Line 1785: hr_utility.trace('sel pay_balance_types TMR');

1781: v_new_balance_type_flag := 'Y';
1782:
1783: WHEN TOO_MANY_ROWS THEN
1784: hrrunprc_trace_on;
1785: hr_utility.trace('sel pay_balance_types TMR');
1786: hr_utility.trace('balance_name ' ||
1787: stu_rec.c_true_key);
1788: hr_utility.trace(':lc: ' || ':' ||
1789: stu_rec.c_leg_code || ':');

Line 1971: from pay_balance_types pb

1967: IS
1968: -- Cursor to fetch balances with same name
1969:
1970: select /*+ INDEX_FFS(pb) */ business_group_id
1971: from pay_balance_types pb
1972: where business_group_id is not null
1973: and replace(ltrim(rtrim(upper(balance_name))), ' ', '_') =
1974: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_');
1975:

Line 2005: from pay_balance_types a

2001: BEGIN
2002:
2003: select distinct null
2004: into l_null_return
2005: from pay_balance_types a
2006: where a.business_group_id is not null
2007: and replace(ltrim(rtrim(upper(a.balance_name))), ' ', '_') =
2008: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_');
2009:

Line 2055: from pay_balance_types

2051:
2052: BEGIN
2053: select distinct null
2054: into l_null_return
2055: from pay_balance_types
2056: where balance_name = stu_rec.c_true_key
2057: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
2058: and (legislation_code is null or stu_rec.c_leg_code is null)
2059: and business_group_id is null;

Line 2106: update pay_balance_types

2102: return;
2103: END;
2104: END IF;
2105:
2106: update pay_balance_types
2107: set business_group_id = null
2108: , legislation_code = stu_rec.c_leg_code
2109: , legislation_subgroup = stu_rec.c_leg_sgrp
2110: , assignment_remuneration_flag=stu_rec.assignment_remuneration_flag

Line 2133: insert into pay_balance_types

2129:
2130: -- No row there to update, must insert
2131:
2132: BEGIN
2133: insert into pay_balance_types
2134: (balance_name
2135: ,balance_type_id
2136: ,legislation_code
2137: ,legislation_subgroup

Line 2173: hr_utility.trace('ins pay_balance_types');

2169: ,stu_rec.base_balance_type_id
2170: ,stu_rec.balance_category_id);
2171: EXCEPTION WHEN OTHERS THEN
2172: hrrunprc_trace_on;
2173: hr_utility.trace('ins pay_balance_types');
2174: hr_utility.trace('bal type id: ' ||
2175: to_char(stu_rec.c_surrogate_key));
2176: hr_utility.trace('bal type name ' ||
2177: stu_rec.c_true_key);

Line 6619: -- PAY_BALANCE_TYPES_TL

6615: ---------------------
6616: IS
6617: -- Install all startup data for multilingual tables.
6618: -- They are:
6619: -- PAY_BALANCE_TYPES_TL
6620: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6621: -- PAY_ELEMENT_TYPES_F_TL
6622: -- PAY_INPUT_VALUES_F_TL
6623: -- PAY_PAYMENT_TYPES_TL

Line 6633: -- Seeds the PAY_BALANCE_TYPES_TL table.

6629:
6630: PROCEDURE install_pbtt
6631: ----------------------
6632: IS
6633: -- Seeds the PAY_BALANCE_TYPES_TL table.
6634:
6635: CURSOR c_input_values IS
6636: select
6637: BT.BALANCE_TYPE_ID,

Line 6647: from PAY_BALANCE_TYPES BT,

6643: BT.LAST_UPDATED_BY,
6644: BT.LAST_UPDATE_LOGIN,
6645: BT.CREATED_BY,
6646: BT.CREATION_DATE
6647: from PAY_BALANCE_TYPES BT,
6648: FND_LANGUAGES L,
6649: FND_LANGUAGES B
6650: where L.INSTALLED_FLAG in ('I', 'B')
6651: and B.INSTALLED_FLAG = 'B'

Line 6656: from pay_balance_types_tl btt

6652: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6653: and (
6654: not exists (
6655: select '1'
6656: from pay_balance_types_tl btt
6657: where btt.balance_type_id = bt.balance_type_id
6658: and btt.language = l.language_code)
6659: or exists (select '1' from pay_balance_types_tl btt2
6660: where btt2.balance_type_id = bt.balance_type_id

Line 6659: or exists (select '1' from pay_balance_types_tl btt2

6655: select '1'
6656: from pay_balance_types_tl btt
6657: where btt.balance_type_id = bt.balance_type_id
6658: and btt.language = l.language_code)
6659: or exists (select '1' from pay_balance_types_tl btt2
6660: where btt2.balance_type_id = bt.balance_type_id
6661: and btt2.language = b.language_code
6662: and nvl(btt2.reporting_name,'XXX') <>
6663: nvl(bt.reporting_name,'XXX'))

Line 6677: delete PAY_BALANCE_TYPES_TL

6673: -- If reporting name for installed lang has changed then remove it
6674: -- before inserting updated reporting name for that installed lang
6675: -- Bug 3280179
6676:
6677: delete PAY_BALANCE_TYPES_TL
6678: where rowid in (select pbttl.rowid
6679: from pay_balance_types pbt,
6680: pay_balance_types_tl pbttl
6681: where pbt.balance_type_id = pbttl.balance_type_id

Line 6679: from pay_balance_types pbt,

6675: -- Bug 3280179
6676:
6677: delete PAY_BALANCE_TYPES_TL
6678: where rowid in (select pbttl.rowid
6679: from pay_balance_types pbt,
6680: pay_balance_types_tl pbttl
6681: where pbt.balance_type_id = pbttl.balance_type_id
6682: and nvl(pbt.reporting_name, 'XXX') <>
6683: nvl(pbttl.reporting_name, 'XXX')

Line 6680: pay_balance_types_tl pbttl

6676:
6677: delete PAY_BALANCE_TYPES_TL
6678: where rowid in (select pbttl.rowid
6679: from pay_balance_types pbt,
6680: pay_balance_types_tl pbttl
6681: where pbt.balance_type_id = pbttl.balance_type_id
6682: and nvl(pbt.reporting_name, 'XXX') <>
6683: nvl(pbttl.reporting_name, 'XXX')
6684: and NVL(TO_CHAR(PBT.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6690: insert into PAY_BALANCE_TYPES_TL

6686: and pbttl.language = l_rec.trans_lang);
6687:
6688: -- Insert all selected rows into the TL table.
6689: -- If the row exist in the TL table then it will be ignored.
6690: insert into PAY_BALANCE_TYPES_TL
6691: (
6692: BALANCE_TYPE_ID,
6693: LANGUAGE,
6694: SOURCE_LANG,

Line 6717: from pay_balance_types_tl btt

6713: l_rec.CREATION_DATE
6714: from dual
6715: where not exists (
6716: select '1'
6717: from pay_balance_types_tl btt
6718: where btt.balance_type_id = l_rec.balance_type_id
6719: and btt.language = l_rec.trans_lang);
6720:
6721: l_counter := l_counter + 1;