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 1232: update hr_s_application_ownerships

1228: update hr_s_formula_result_rules_f
1229: set element_type_id = l_new_element_type_id
1230: where element_type_id = r_distinct.c_surrogate_key;
1231:
1232: update hr_s_application_ownerships
1233: set key_value = to_char(l_new_element_type_id)
1234: where key_value = to_char(r_distinct.c_surrogate_key)
1235: and key_name = 'ELEMENT_TYPE_ID';
1236:

Line 1814: from hr_s_application_ownerships a

1810: into l_null_Return
1811: from dual
1812: where exists (
1813: select null
1814: from hr_s_application_ownerships a
1815: , fnd_product_installations b
1816: , fnd_application c
1817: where a.key_name = 'ELEMENT_TYPE_ID'
1818: and a.key_value = r_distinct.c_surrogate_key

Line 1830: from hr_s_application_ownerships a

1826: into l_null_Return
1827: from dual
1828: where exists (
1829: select null
1830: from hr_s_application_ownerships a
1831: , fnd_product_installations b
1832: , fnd_application c
1833: where a.key_name = 'ELEMENT_TYPE_ID'
1834: and a.key_value = r_distinct.c_surrogate_key

Line 2766: update hr_s_application_ownerships

2762:
2763: update /*+NO_INDEX*/ hr_s_ele_classn_rules
2764: set element_set_id = element_set_id - 50000000;
2765:
2766: update hr_s_application_ownerships
2767: set key_value = key_value - 50000000
2768: where key_name = 'ELEMENT_SET_ID';
2769:
2770: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 2865: update hr_s_application_ownerships

2861: update hr_s_element_sets
2862: set element_set_id = l_new_surrogate_key
2863: where element_set_id = stu_rec.c_surrogate_key;
2864:
2865: update hr_s_application_ownerships
2866: set key_value = to_char(l_new_surrogate_key)
2867: where key_value = to_char(stu_rec.c_surrogate_key)
2868: and key_name = 'ELEMENT_SET_ID';
2869:

Line 2940: from hr_s_application_ownerships a

2936: into l_null_return
2937: from dual
2938: where exists
2939: (select null
2940: from hr_s_application_ownerships a
2941: , fnd_product_installations b
2942: , fnd_application c
2943: where a.key_name = 'ELEMENT_SET_ID'
2944: and a.key_value = stu_rec.c_surrogate_key

Line 3367: update hr_s_application_ownerships

3363:
3364: update /*+NO_INDEX*/ hr_s_user_tables
3365: set user_table_id = user_table_id - 50000000;
3366:
3367: update hr_s_application_ownerships
3368: set key_value = key_value - 50000000
3369: where key_name = 'USER_TABLE_ID';
3370:
3371: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3467: update hr_s_application_ownerships

3463: update hr_s_user_tables
3464: set user_table_id = l_new_surrogate_key
3465: where user_table_id = stu_rec.c_surrogate_key;
3466:
3467: update hr_s_application_ownerships
3468: set key_value = to_char(l_new_surrogate_key)
3469: where key_value = to_char(stu_rec.c_surrogate_key)
3470: and key_name = 'USER_TABLE_ID';
3471:

Line 3535: from hr_s_application_ownerships a

3531: into l_null_return
3532: from dual
3533: where exists
3534: (select null
3535: from hr_s_application_ownerships a
3536: , fnd_product_installations b
3537: , fnd_application c
3538: where a.key_name = 'USER_TABLE_ID'
3539: and a.key_value = stu_rec.c_surrogate_key

Line 3551: from hr_s_application_ownerships a

3547: into l_null_return
3548: from dual
3549: where exists
3550: (select null
3551: from hr_s_application_ownerships a
3552: , fnd_product_installations b
3553: , fnd_application c
3554: where a.key_name = 'USER_TABLE_ID'
3555: and a.key_value = stu_rec.c_surrogate_key

Line 3880: update hr_s_application_ownerships

3876:
3877: update /*+NO_INDEX*/ hr_s_user_column_instances_f
3878: set user_column_id = user_column_id - 50000000;
3879:
3880: update hr_s_application_ownerships
3881: set key_value = key_value - 50000000
3882: where key_name = 'USER_COLUMN_ID';
3883:
3884: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3987: update hr_s_application_ownerships

3983: update hr_s_user_columns
3984: set user_column_id = l_new_surrogate_key
3985: where user_column_id = stu_rec.c_surrogate_key;
3986:
3987: update hr_s_application_ownerships
3988: set key_value = to_char(l_new_surrogate_key)
3989: where key_value = to_char(stu_rec.c_surrogate_key)
3990: and key_name = 'USER_COLUMN_ID';
3991:

Line 4053: from hr_s_application_ownerships a

4049: into l_null_return
4050: from dual
4051: where exists
4052: (select null
4053: from hr_s_application_ownerships a
4054: , fnd_product_installations b
4055: , fnd_application c
4056: where a.key_name = 'USER_COLUMN_ID'
4057: and a.key_value = stu_rec.c_surrogate_key

Line 4069: from hr_s_application_ownerships a

4065: into l_null_return
4066: from dual
4067: where exists
4068: (select null
4069: from hr_s_application_ownerships a
4070: , fnd_product_installations b
4071: , fnd_application c
4072: where a.key_name = 'USER_COLUMN_ID'
4073: and a.key_value = stu_rec.c_surrogate_key