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_DEFINED_BALANCES

Line 276: -- pay_defined_balances to not included

272: -- create balance feeds for existing
273: -- elements with same classification as
274: -- the balance classification inserted.
275: -- 115.78 RThirlby 06-AUG-2002 Bug 2496207 - changed update of
276: -- pay_defined_balances to not included
277: -- RUN_BALANCE_STATUS, so this column will
278: -- retain its original value.
279: -- 115.79 DVickers 12-AUG-2002 Managed db sequence fix
280: -- 115.80 DVickers 27-SEP-2002 HR_S->HR_APP_OWN move for ZZ leg

Line 296: -- pay_defined_balances. Bug 2906340

292: -- 115.90 DVickers 14-MAR-2003 explicit hrsao.key_value conversion
293: -- 115.91 DVickers 17-MAR-2003 Fix for correcting sync up of base_
294: -- balance_type_id
295: -- 115.92 DVickers 15-APR-2003 Added bg null check for update_uid
296: -- pay_defined_balances. Bug 2906340
297: -- 115.93 DVickers 24-APR-2003 Fix for delete of dt user_rows, cols
298: -- 115.94 DVickers 06-MAY-2003 del dim routes based on bal dim id
299: -- and priority not route_id
300: -- 115.95 DVickers 04-JUN-2003 new_category_name rollback correction

Line 571: ,pay_defined_balances pdb

567: SELECT distinct ao.key_name
568: ,ao.product_name
569: ,ao.key_value
570: FROM hr_s_application_ownerships ao
571: ,pay_defined_balances pdb
572: WHERE pdb.legislation_code ='ZZ'
573: AND ao.key_name = 'DEFINED_BALANCE_ID'
574: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id
575: AND NOT EXISTS (SELECT null

Line 1667: from pay_defined_balances a

1663:
1664:
1665: select distinct null
1666: into l_null_return
1667: from pay_defined_balances a
1668: where exists
1669: (select null
1670: from hr_s_defined_balances b
1671: where a.defined_balance_id = b.defined_balance_id

Line 1721: select pay_defined_balances_s.nextval

1717: into v_min_delivered
1718: , v_max_delivered
1719: from hr_s_defined_balances;
1720:
1721: select pay_defined_balances_s.nextval
1722: into v_sequence_number
1723: from dual;
1724:
1725: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN

Line 1727: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',

1723: from dual;
1724:
1725: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN
1726:
1727: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',
1728: v_sequence_number,
1729: v_max_delivered);
1730:
1731: END IF;

Line 1830: from pay_defined_balances

1826: BEGIN
1827:
1828: select defined_balance_id
1829: into v_new_def_bal_id
1830: from pay_defined_balances
1831: where balance_type_id = l_new_surrogate_key
1832: and balance_dimension_id = def_bals.balance_dimension_id
1833: and business_group_id is null
1834: and ( (legislation_code is null and def_bals.legislation_code is null)

Line 1839: select pay_defined_balances_s.nextval

1835: or (legislation_code = def_bals.legislation_code) );
1836:
1837: EXCEPTION WHEN NO_DATA_FOUND THEN
1838:
1839: select pay_defined_balances_s.nextval
1840: into v_new_def_bal_id
1841: from dual;
1842:
1843: WHEN TOO_MANY_ROWS THEN

Line 1845: hr_utility.trace('sel pay_defined_balances TMR');

1841: from dual;
1842:
1843: WHEN TOO_MANY_ROWS THEN
1844: hrrunprc_trace_on;
1845: hr_utility.trace('sel pay_defined_balances TMR');
1846: hr_utility.trace('balance_type_id ' ||
1847: to_char(l_new_surrogate_key));
1848: hr_utility.trace('balance_name ' ||
1849: stu_rec.c_true_key);

Line 2325: update pay_defined_balances

2321: return;
2322:
2323: END;
2324:
2325: update pay_defined_balances
2326: set BUSINESS_GROUP_ID = null,
2327: LEGISLATION_CODE = def_bals.LEGISLATION_CODE,
2328: BALANCE_TYPE_ID = def_bals.BALANCE_TYPE_ID,
2329: BALANCE_DIMENSION_ID = def_bals.BALANCE_DIMENSION_ID,

Line 2345: insert into pay_defined_balances

2341:
2342: IF SQL%NOTFOUND THEN
2343: -- doesn't exist so do insert
2344: BEGIN
2345: insert into pay_defined_balances
2346: (DEFINED_BALANCE_ID
2347: ,BUSINESS_GROUP_ID
2348: ,LEGISLATION_CODE
2349: ,BALANCE_TYPE_ID

Line 3059: pay_defined_balances db,

3055: where formula_id in (
3056: select fdi.formula_id
3057: from ff_fdi_usages_f fdi,
3058: ff_user_entities ue,
3059: pay_defined_balances db,
3060: pay_balance_dimensions bd,
3061: ff_database_items di
3062: where fdi.item_name = di.user_name
3063: and ue.creator_type = 'B'

Line 3074: pay_defined_balances db,

3070: where fdi2.formula_id in
3071: (select fdi.formula_id
3072: from ff_fdi_usages_f fdi,
3073: ff_user_entities ue,
3074: pay_defined_balances db,
3075: pay_balance_dimensions bd,
3076: ff_database_items di
3077: where fdi.item_name = di.user_name
3078: and ue.creator_type = 'B'

Line 3088: from pay_defined_balances pdb

3084: delete from ff_user_entities
3085: where creator_type = 'B'
3086: and creator_id in
3087: (select defined_balance_id
3088: from pay_defined_balances pdb
3089: where pdb.balance_dimension_id = stu_rec.c_surrogate_key);
3090:
3091: end if;
3092: