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 568: elsif l_table_name = 'PAY_BALANCE_TYPES' then

564: and et.created_by > 2
565: and et.last_updated_by > 2
566: and replace(ltrim(rtrim(upper(et.ELEMENT_NAME))), ' ', '_') = replace(ltrim(rtrim(upper(P_SURROGATE_KEY_NAME))), ' ', '_'));
567:
568: elsif l_table_name = 'PAY_BALANCE_TYPES' then
569:
570: Select 'Y' into v_exists from dual where exists (
571: select null
572: from PAY_BALANCE_TYPES bt

Line 572: from PAY_BALANCE_TYPES bt

568: elsif l_table_name = 'PAY_BALANCE_TYPES' then
569:
570: Select 'Y' into v_exists from dual where exists (
571: select null
572: from PAY_BALANCE_TYPES bt
573: where bt.business_group_id is null
574: and bt.legislation_code = p_legislation_code
575: and bt.created_by > 2
576: and bt.last_updated_by > 2

Line 599: from pay_defined_balances pdb, pay_balance_dimensions pbd, pay_balance_types pbt

595: elsif l_table_name='PAY_DEFINED_BALANCES' then
596:
597: Select 'Y' into v_exists from dual where exists(
598: select null
599: from pay_defined_balances pdb, pay_balance_dimensions pbd, pay_balance_types pbt
600: where pdb.business_group_id is null
601: and pdb.legislation_code = p_legislation_code
602: and pdb.created_by > 2
603: and pdb.last_updated_by > 2

Line 615: pay_balance_types bt

611: Select 'Y' into v_exists from dual where exists(
612: select null
613: from pay_balance_feeds_f bf,
614: pay_input_values_f piv,
615: pay_balance_types bt
616: where piv.input_value_id = bf.INPUT_VALUE_ID
617: and bt.balance_type_id = bf.balance_type_id
618: and bf.business_group_id is null
619: and bf.legislation_code = p_legislation_code

Line 748: ,pay_balance_types pbt

744: SELECT distinct ao.key_name
745: ,ao.product_name
746: ,ao.key_value
747: FROM hr_s_application_ownerships ao
748: ,pay_balance_types pbt
749: WHERE pbt.legislation_code = 'ZZ'
750: AND ao.key_name = 'BALANCE_TYPE_ID'
751: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
752: AND NOT EXISTS (SELECT null

Line 1689: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_TYPES

1685:
1686: END install_bal_categories;
1687:
1688: --****************************************************************************
1689: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_TYPES
1690: --****************************************************************************
1691:
1692: PROCEDURE install_bal_types (p_phase IN number)
1693: -----------------------------------------------

Line 1826: from pay_balance_types a

1822:
1823:
1824: select distinct null
1825: into l_null_return
1826: from pay_balance_types a
1827: where exists
1828: (select null
1829: from hr_s_balance_types b
1830: where a.balance_type_id = b.balance_type_id

Line 1897: from pay_balance_types;

1893: from hr_s_balance_types;
1894:
1895: select max(balance_type_id)
1896: into v_max_live
1897: from pay_balance_types;
1898:
1899: select pay_balance_types_s.nextval
1900: into v_sequence_number
1901: from dual;

Line 1899: select pay_balance_types_s.nextval

1895: select max(balance_type_id)
1896: into v_max_live
1897: from pay_balance_types;
1898:
1899: select pay_balance_types_s.nextval
1900: into v_sequence_number
1901: from dual;
1902:
1903: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 1908: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1904: OR (v_sequence_number < v_max_live) THEN
1905:
1906: IF v_max_live > v_max_delivered THEN
1907:
1908: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1909: v_sequence_number,
1910: v_max_live);
1911: ELSE
1912:

Line 1913: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',

1909: v_sequence_number,
1910: v_max_live);
1911: ELSE
1912:
1913: hr_legislation.munge_sequence('PAY_BALANCE_TYPES_S',
1914: v_sequence_number,
1915: v_max_delivered);
1916: END IF;
1917: END IF;

Line 1951: insert_hr_stu_exceptions('pay_balance_types'

1947:
1948: BEGIN
1949:
1950: rollback to new_balance_name;
1951: insert_hr_stu_exceptions('pay_balance_types'
1952: , stu_rec.c_surrogate_key
1953: , exception_type
1954: , stu_rec.c_true_key);
1955:

Line 1973: P_TABLE_NAME => 'PAY_BALANCE_TYPES',

1969:
1970: -- Check if we have a pseduo seed clash if enabled
1971: -- Error handling is done in the procedure itself
1972: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,
1973: P_TABLE_NAME => 'PAY_BALANCE_TYPES',
1974: P_LEGISLATION_CODE => stu_rec.c_leg_code);
1975: END IF;
1976:
1977:

Line 1982: from pay_balance_types

1978: BEGIN
1979:
1980: select distinct balance_type_id
1981: into l_new_surrogate_key
1982: from pay_balance_types
1983: where replace(ltrim(rtrim(upper(balance_name))), ' ', '_') =
1984: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_')
1985: and business_group_id is null
1986: and ( (legislation_code is null and stu_rec.c_leg_code is null)

Line 1994: select pay_balance_types_s.nextval

1990:
1991: EXCEPTION WHEN NO_DATA_FOUND THEN
1992:
1993:
1994: select pay_balance_types_s.nextval
1995: into l_new_surrogate_key
1996: from dual;
1997:
1998: v_new_balance_type_flag := 'Y';

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

1998: v_new_balance_type_flag := 'Y';
1999:
2000: WHEN TOO_MANY_ROWS THEN
2001: hrrunprc_trace_on;
2002: hr_utility.trace('sel pay_balance_types TMR');
2003: hr_utility.trace('balance_name ' ||
2004: stu_rec.c_true_key);
2005: hr_utility.trace(':lc: ' || ':' ||
2006: stu_rec.c_leg_code || ':');

Line 2188: from pay_balance_types pb

2184: IS
2185: -- Cursor to fetch balances with same name
2186:
2187: select /*+ INDEX_FFS(pb) */ business_group_id
2188: from pay_balance_types pb
2189: where business_group_id is not null
2190: and replace(ltrim(rtrim(upper(balance_name))), ' ', '_') =
2191: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_');
2192:

Line 2222: from pay_balance_types a

2218: BEGIN
2219:
2220: select distinct null
2221: into l_null_return
2222: from pay_balance_types a
2223: where a.business_group_id is not null
2224: and replace(ltrim(rtrim(upper(a.balance_name))), ' ', '_') =
2225: replace(ltrim(rtrim(upper(stu_rec.c_true_key))), ' ', '_');
2226:

Line 2272: from pay_balance_types

2268:
2269: BEGIN
2270: select distinct null
2271: into l_null_return
2272: from pay_balance_types
2273: where balance_name = stu_rec.c_true_key
2274: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
2275: and (legislation_code is null or stu_rec.c_leg_code is null)
2276: and business_group_id is null;

Line 2293: P_TABLE_NAME => 'PAY_BALANCE_TYPES',

2289: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
2290: -- Check if we have a pseduo seed clash if enabled
2291: -- Error handling is done in the procedure itself
2292: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => stu_rec.c_true_key,
2293: P_TABLE_NAME => 'PAY_BALANCE_TYPES',
2294: P_LEGISLATION_CODE => stu_rec.c_leg_code);
2295: END IF;
2296:
2297: end if;

Line 2333: update pay_balance_types

2329: return;
2330: END;
2331: END IF;
2332:
2333: update pay_balance_types
2334: set business_group_id = null
2335: , legislation_code = stu_rec.c_leg_code
2336: , legislation_subgroup = stu_rec.c_leg_sgrp
2337: , assignment_remuneration_flag=stu_rec.assignment_remuneration_flag

Line 2360: insert into pay_balance_types

2356:
2357: -- No row there to update, must insert
2358:
2359: BEGIN
2360: insert into pay_balance_types
2361: (balance_name
2362: ,balance_type_id
2363: ,legislation_code
2364: ,legislation_subgroup

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

2396: ,stu_rec.base_balance_type_id
2397: ,stu_rec.balance_category_id);
2398: EXCEPTION WHEN OTHERS THEN
2399: hrrunprc_trace_on;
2400: hr_utility.trace('ins pay_balance_types');
2401: hr_utility.trace('bal type id: ' ||
2402: to_char(stu_rec.c_surrogate_key));
2403: hr_utility.trace('bal type name ' ||
2404: stu_rec.c_true_key);

Line 6869: -- PAY_BALANCE_TYPES_TL

6865: ---------------------
6866: IS
6867: -- Install all startup data for multilingual tables.
6868: -- They are:
6869: -- PAY_BALANCE_TYPES_TL
6870: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6871: -- PAY_ELEMENT_TYPES_F_TL
6872: -- PAY_INPUT_VALUES_F_TL
6873: -- PAY_PAYMENT_TYPES_TL

Line 6883: -- Seeds the PAY_BALANCE_TYPES_TL table.

6879:
6880: PROCEDURE install_pbtt
6881: ----------------------
6882: IS
6883: -- Seeds the PAY_BALANCE_TYPES_TL table.
6884:
6885: CURSOR c_input_values IS
6886: select
6887: BT.BALANCE_TYPE_ID,

Line 6897: from PAY_BALANCE_TYPES BT,

6893: BT.LAST_UPDATED_BY,
6894: BT.LAST_UPDATE_LOGIN,
6895: BT.CREATED_BY,
6896: BT.CREATION_DATE
6897: from PAY_BALANCE_TYPES BT,
6898: FND_LANGUAGES L,
6899: FND_LANGUAGES B
6900: where L.INSTALLED_FLAG in ('I', 'B')
6901: and B.INSTALLED_FLAG = 'B'

Line 6906: from pay_balance_types_tl btt

6902: and NVL(TO_CHAR(BT.BUSINESS_GROUP_ID),'Null Value')='Null Value'
6903: and (
6904: not exists (
6905: select '1'
6906: from pay_balance_types_tl btt
6907: where btt.balance_type_id = bt.balance_type_id
6908: and btt.language = l.language_code)
6909: or exists (select '1' from pay_balance_types_tl btt2
6910: where btt2.balance_type_id = bt.balance_type_id

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

6905: select '1'
6906: from pay_balance_types_tl btt
6907: where btt.balance_type_id = bt.balance_type_id
6908: and btt.language = l.language_code)
6909: or exists (select '1' from pay_balance_types_tl btt2
6910: where btt2.balance_type_id = bt.balance_type_id
6911: and btt2.language = b.language_code
6912: and nvl(btt2.reporting_name,'XXX') <>
6913: nvl(bt.reporting_name,'XXX'))

Line 6927: delete PAY_BALANCE_TYPES_TL

6923: -- If reporting name for installed lang has changed then remove it
6924: -- before inserting updated reporting name for that installed lang
6925: -- Bug 3280179
6926:
6927: delete PAY_BALANCE_TYPES_TL
6928: where rowid in (select pbttl.rowid
6929: from pay_balance_types pbt,
6930: pay_balance_types_tl pbttl
6931: where pbt.balance_type_id = pbttl.balance_type_id

Line 6929: from pay_balance_types pbt,

6925: -- Bug 3280179
6926:
6927: delete PAY_BALANCE_TYPES_TL
6928: where rowid in (select pbttl.rowid
6929: from pay_balance_types pbt,
6930: pay_balance_types_tl pbttl
6931: where pbt.balance_type_id = pbttl.balance_type_id
6932: and nvl(pbt.reporting_name, 'XXX') <>
6933: nvl(pbttl.reporting_name, 'XXX')

Line 6930: pay_balance_types_tl pbttl

6926:
6927: delete PAY_BALANCE_TYPES_TL
6928: where rowid in (select pbttl.rowid
6929: from pay_balance_types pbt,
6930: pay_balance_types_tl pbttl
6931: where pbt.balance_type_id = pbttl.balance_type_id
6932: and nvl(pbt.reporting_name, 'XXX') <>
6933: nvl(pbttl.reporting_name, 'XXX')
6934: and NVL(TO_CHAR(PBT.BUSINESS_GROUP_ID),'Null Value')='Null Value'

Line 6940: insert into PAY_BALANCE_TYPES_TL

6936: and pbttl.language = l_rec.trans_lang);
6937:
6938: -- Insert all selected rows into the TL table.
6939: -- If the row exist in the TL table then it will be ignored.
6940: insert into PAY_BALANCE_TYPES_TL
6941: (
6942: BALANCE_TYPE_ID,
6943: LANGUAGE,
6944: SOURCE_LANG,

Line 6967: from pay_balance_types_tl btt

6963: l_rec.CREATION_DATE
6964: from dual
6965: where not exists (
6966: select '1'
6967: from pay_balance_types_tl btt
6968: where btt.balance_type_id = l_rec.balance_type_id
6969: and btt.language = l_rec.trans_lang);
6970:
6971: l_counter := l_counter + 1;