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_ELEMENTS dependencies on HR_S_APPLICATION_OWNERSHIPS

Line 137: update hr_s_application_ownerships

133: --
134: update /*+NO_INDEX*/ hr_s_TAXABILITY_RULES
135: set classification_id = classification_id - 50000000;
136:
137: update hr_s_application_ownerships
138: set key_value = key_value - 50000000
139: where key_name = 'CLASSIFICATION_ID';
140:
141: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 288: update hr_s_application_ownerships

284: update hr_s_element_classifications
285: set parent_classification_id = l_new_surrogate_key
286: where parent_classification_id = stu_rec.c_surrogate_key;
287:
288: update hr_s_application_ownerships
289: set key_value = to_char(l_new_surrogate_key)
290: where key_value = to_char(stu_rec.c_surrogate_key)
291: and key_name = 'CLASSIFICATION_ID';
292:

Line 377: from hr_s_application_ownerships a

373: into l_null_return
374: from dual
375: where exists
376: (select null
377: from hr_s_application_ownerships a
378: , fnd_product_installations b
379: , fnd_application c
380: where a.key_name = 'CLASSIFICATION_ID'
381: and a.key_value = stu_rec.c_surrogate_key

Line 393: from hr_s_application_ownerships a

389: into l_null_return
390: from dual
391: where exists
392: (select null
393: from hr_s_application_ownerships a
394: , fnd_product_installations b
395: , fnd_application c
396: where a.key_name = 'CLASSIFICATION_ID'
397: and a.key_value = stu_rec.c_surrogate_key

Line 869: update hr_s_application_ownerships

865:
866: update /*+NO_INDEX*/ hr_s_SUB_CLASSN_RULES_F
867: set element_type_id = element_type_id - 50000000;
868:
869: update hr_s_application_ownerships
870: set key_value = key_value - 50000000
871: where key_name = 'ELEMENT_TYPE_ID';
872:
873: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 1245: update hr_s_application_ownerships

1241: update hr_s_formula_result_rules_f
1242: set element_type_id = l_new_element_type_id
1243: where element_type_id = r_distinct.c_surrogate_key;
1244:
1245: update hr_s_application_ownerships
1246: set key_value = to_char(l_new_element_type_id)
1247: where key_value = to_char(r_distinct.c_surrogate_key)
1248: and key_name = 'ELEMENT_TYPE_ID';
1249:

Line 1835: from hr_s_application_ownerships a

1831: into l_null_Return
1832: from dual
1833: where exists (
1834: select null
1835: from hr_s_application_ownerships a
1836: , fnd_product_installations b
1837: , fnd_application c
1838: where a.key_name = 'ELEMENT_TYPE_ID'
1839: and a.key_value = r_distinct.c_surrogate_key

Line 1851: from hr_s_application_ownerships a

1847: into l_null_Return
1848: from dual
1849: where exists (
1850: select null
1851: from hr_s_application_ownerships a
1852: , fnd_product_installations b
1853: , fnd_application c
1854: where a.key_name = 'ELEMENT_TYPE_ID'
1855: and a.key_value = r_distinct.c_surrogate_key

Line 2798: update hr_s_application_ownerships

2794:
2795: update /*+NO_INDEX*/ hr_s_ele_classn_rules
2796: set element_set_id = element_set_id - 50000000;
2797:
2798: update hr_s_application_ownerships
2799: set key_value = key_value - 50000000
2800: where key_name = 'ELEMENT_SET_ID';
2801:
2802: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 2897: update hr_s_application_ownerships

2893: update hr_s_element_sets
2894: set element_set_id = l_new_surrogate_key
2895: where element_set_id = stu_rec.c_surrogate_key;
2896:
2897: update hr_s_application_ownerships
2898: set key_value = to_char(l_new_surrogate_key)
2899: where key_value = to_char(stu_rec.c_surrogate_key)
2900: and key_name = 'ELEMENT_SET_ID';
2901:

Line 2972: from hr_s_application_ownerships a

2968: into l_null_return
2969: from dual
2970: where exists
2971: (select null
2972: from hr_s_application_ownerships a
2973: , fnd_product_installations b
2974: , fnd_application c
2975: where a.key_name = 'ELEMENT_SET_ID'
2976: and a.key_value = stu_rec.c_surrogate_key

Line 3399: update hr_s_application_ownerships

3395:
3396: update /*+NO_INDEX*/ hr_s_user_tables
3397: set user_table_id = user_table_id - 50000000;
3398:
3399: update hr_s_application_ownerships
3400: set key_value = key_value - 50000000
3401: where key_name = 'USER_TABLE_ID';
3402:
3403: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3499: update hr_s_application_ownerships

3495: update hr_s_user_tables
3496: set user_table_id = l_new_surrogate_key
3497: where user_table_id = stu_rec.c_surrogate_key;
3498:
3499: update hr_s_application_ownerships
3500: set key_value = to_char(l_new_surrogate_key)
3501: where key_value = to_char(stu_rec.c_surrogate_key)
3502: and key_name = 'USER_TABLE_ID';
3503:

Line 3567: from hr_s_application_ownerships a

3563: into l_null_return
3564: from dual
3565: where exists
3566: (select null
3567: from hr_s_application_ownerships a
3568: , fnd_product_installations b
3569: , fnd_application c
3570: where a.key_name = 'USER_TABLE_ID'
3571: and a.key_value = stu_rec.c_surrogate_key

Line 3583: from hr_s_application_ownerships a

3579: into l_null_return
3580: from dual
3581: where exists
3582: (select null
3583: from hr_s_application_ownerships a
3584: , fnd_product_installations b
3585: , fnd_application c
3586: where a.key_name = 'USER_TABLE_ID'
3587: and a.key_value = stu_rec.c_surrogate_key

Line 3912: update hr_s_application_ownerships

3908:
3909: update /*+NO_INDEX*/ hr_s_user_column_instances_f
3910: set user_column_id = user_column_id - 50000000;
3911:
3912: update hr_s_application_ownerships
3913: set key_value = key_value - 50000000
3914: where key_name = 'USER_COLUMN_ID';
3915:
3916: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4019: update hr_s_application_ownerships

4015: update hr_s_user_columns
4016: set user_column_id = l_new_surrogate_key
4017: where user_column_id = stu_rec.c_surrogate_key;
4018:
4019: update hr_s_application_ownerships
4020: set key_value = to_char(l_new_surrogate_key)
4021: where key_value = to_char(stu_rec.c_surrogate_key)
4022: and key_name = 'USER_COLUMN_ID';
4023:

Line 4085: from hr_s_application_ownerships a

4081: into l_null_return
4082: from dual
4083: where exists
4084: (select null
4085: from hr_s_application_ownerships a
4086: , fnd_product_installations b
4087: , fnd_application c
4088: where a.key_name = 'USER_COLUMN_ID'
4089: and a.key_value = stu_rec.c_surrogate_key

Line 4101: from hr_s_application_ownerships a

4097: into l_null_return
4098: from dual
4099: where exists
4100: (select null
4101: from hr_s_application_ownerships a
4102: , fnd_product_installations b
4103: , fnd_application c
4104: where a.key_name = 'USER_COLUMN_ID'
4105: and a.key_value = stu_rec.c_surrogate_key