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 595: elsif l_table_name='PAY_DEFINED_BALANCES' then

591: and iv.last_updated_by > 2
592: and replace(ltrim(rtrim(upper(iv.NAME))), ' ', '_') = replace(ltrim(rtrim(upper(P_SURROGATE_KEY_NAME))), ' ', '_')
593: and replace(ltrim(rtrim(upper(et.ELEMENT_NAME))), ' ', '_') = replace(ltrim(rtrim(upper(P_ADDL_SURROGATE_KEY_NAME1))), ' ', '_'));
594:
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

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 776: ,pay_defined_balances pdb

772: SELECT distinct ao.key_name
773: ,ao.product_name
774: ,ao.key_value
775: FROM hr_s_application_ownerships ao
776: ,pay_defined_balances pdb
777: WHERE pdb.legislation_code ='ZZ'
778: AND ao.key_name = 'DEFINED_BALANCE_ID'
779: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id
780: AND NOT EXISTS (SELECT null

Line 1872: from pay_defined_balances a

1868:
1869:
1870: select distinct null
1871: into l_null_return
1872: from pay_defined_balances a
1873: where exists
1874: (select null
1875: from hr_s_defined_balances b
1876: where a.defined_balance_id = b.defined_balance_id

Line 1926: select pay_defined_balances_s.nextval

1922: into v_min_delivered
1923: , v_max_delivered
1924: from hr_s_defined_balances;
1925:
1926: select pay_defined_balances_s.nextval
1927: into v_sequence_number
1928: from dual;
1929:
1930: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN

Line 1932: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',

1928: from dual;
1929:
1930: IF v_sequence_number BETWEEN v_min_delivered AND v_max_delivered THEN
1931:
1932: hr_legislation.munge_sequence('PAY_DEFINED_BALANCES_S',
1933: v_sequence_number,
1934: v_max_delivered);
1935:
1936: END IF;

Line 2047: from pay_defined_balances

2043: BEGIN
2044:
2045: select defined_balance_id
2046: into v_new_def_bal_id
2047: from pay_defined_balances
2048: where balance_type_id = l_new_surrogate_key
2049: and balance_dimension_id = def_bals.balance_dimension_id
2050: and business_group_id is null
2051: and ( (legislation_code is null and def_bals.legislation_code is null)

Line 2056: select pay_defined_balances_s.nextval

2052: or (legislation_code = def_bals.legislation_code) );
2053:
2054: EXCEPTION WHEN NO_DATA_FOUND THEN
2055:
2056: select pay_defined_balances_s.nextval
2057: into v_new_def_bal_id
2058: from dual;
2059:
2060: WHEN TOO_MANY_ROWS THEN

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

2058: from dual;
2059:
2060: WHEN TOO_MANY_ROWS THEN
2061: hrrunprc_trace_on;
2062: hr_utility.trace('sel pay_defined_balances TMR');
2063: hr_utility.trace('balance_type_id ' ||
2064: to_char(l_new_surrogate_key));
2065: hr_utility.trace('balance_name ' ||
2066: stu_rec.c_true_key);

Line 2552: update pay_defined_balances

2548: return;
2549:
2550: END;
2551:
2552: update pay_defined_balances
2553: set BUSINESS_GROUP_ID = null,
2554: LEGISLATION_CODE = def_bals.LEGISLATION_CODE,
2555: BALANCE_TYPE_ID = def_bals.BALANCE_TYPE_ID,
2556: BALANCE_DIMENSION_ID = def_bals.BALANCE_DIMENSION_ID,

Line 2572: insert into pay_defined_balances

2568:
2569: IF SQL%NOTFOUND THEN
2570: -- doesn't exist so do insert
2571: BEGIN
2572: insert into pay_defined_balances
2573: (DEFINED_BALANCE_ID
2574: ,BUSINESS_GROUP_ID
2575: ,LEGISLATION_CODE
2576: ,BALANCE_TYPE_ID

Line 3305: pay_defined_balances db,

3301: where formula_id in (
3302: select fdi.formula_id
3303: from ff_fdi_usages_f fdi,
3304: ff_user_entities ue,
3305: pay_defined_balances db,
3306: pay_balance_dimensions bd,
3307: ff_database_items di
3308: where fdi.item_name = di.user_name
3309: and ue.creator_type = 'B'

Line 3320: pay_defined_balances db,

3316: where fdi2.formula_id in
3317: (select fdi.formula_id
3318: from ff_fdi_usages_f fdi,
3319: ff_user_entities ue,
3320: pay_defined_balances db,
3321: pay_balance_dimensions bd,
3322: ff_database_items di
3323: where fdi.item_name = di.user_name
3324: and ue.creator_type = 'B'

Line 3334: from pay_defined_balances pdb

3330: delete from ff_user_entities
3331: where creator_type = 'B'
3332: and creator_id in
3333: (select defined_balance_id
3334: from pay_defined_balances pdb
3335: where pdb.balance_dimension_id = stu_rec.c_surrogate_key);
3336:
3337: end if;
3338: