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 HR_S_APPLICATION_OWNERSHIPS

Line 733: FROM hr_s_application_ownerships ao

729: ,key_value)
730: SELECT distinct ao.key_name
731: ,ao.product_name
732: ,ao.key_value
733: FROM hr_s_application_ownerships ao
734: ,pay_element_classifications pec
735: WHERE pec.legislation_code = 'ZZ'
736: AND ao.key_name = 'CLASSIFICATION_ID'
737: AND TO_NUMBER(ao.key_value) = pec.classification_id

Line 747: FROM hr_s_application_ownerships ao

743: UNION ALL
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

Line 761: FROM hr_s_application_ownerships ao

757: UNION ALL
758: SELECT distinct ao.key_name
759: ,ao.product_name
760: ,ao.key_value
761: FROM hr_s_application_ownerships ao
762: ,pay_balance_dimensions pbd
763: WHERE pbd.legislation_code ='ZZ'
764: AND ao.key_name = 'BALANCE_DIMENSION_ID'
765: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id

Line 775: FROM hr_s_application_ownerships ao

771: UNION ALL
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

Line 789: FROM hr_s_application_ownerships ao

785: UNION ALL
786: SELECT distinct ao.key_name
787: ,ao.product_name
788: ,ao.key_value
789: FROM hr_s_application_ownerships ao
790: ,ff_routes fr
791: ,pay_balance_dimensions pbd
792: WHERE pbd.legislation_code ='ZZ'
793: AND ao.key_name = 'ROUTE_ID'

Line 919: update hr_s_application_ownerships

915:
916: update /*+NO_INDEX*/ hr_s_status_processing_rules_f
917: set assignment_status_type_id=assignment_status_type_id - 50000000;
918:
919: update hr_s_application_ownerships
920: set key_value = key_value - 50000000
921: where key_name = 'ASSIGNMENT_STATUS_TYPE_ID';
922:
923: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 1020: update hr_s_application_ownerships

1016: update hr_s_status_processing_rules_f
1017: set assignment_status_type_id = l_new_surrogate_key
1018: where assignment_status_type_id = stu_rec.c_surrogate_key;
1019:
1020: update hr_s_application_ownerships
1021: set key_value = to_char(l_new_surrogate_key)
1022: where key_value = to_char(stu_rec.c_surrogate_key)
1023: and key_name = 'ASSIGNMENT_STATUS_TYPE_ID';
1024:

Line 1084: from hr_s_application_ownerships a

1080: into l_null_return
1081: from dual
1082: where exists (
1083: select null
1084: from hr_s_application_ownerships a
1085: , fnd_product_installations b
1086: , fnd_application c
1087: where a.key_name = 'ASSIGNMENT_STATUS_TYPE_ID'
1088: and a.key_value = l_new_surrogate_key

Line 1851: update hr_s_application_ownerships

1847:
1848: update /*+NO_INDEX*/ hr_s_DEFINED_BALANCES
1849: set balance_type_id = balance_type_id - 50000000;
1850:
1851: update hr_s_application_ownerships
1852: set key_value = key_value - 50000000
1853: where key_name = 'BALANCE_TYPE_ID';
1854:
1855: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 2022: update hr_s_application_ownerships

2018: set base_balance_type_id = l_new_surrogate_key,
2019: new_balance_type_flag = v_new_balance_type_flag
2020: where base_balance_type_id = stu_rec.c_surrogate_key;
2021:
2022: update hr_s_application_ownerships
2023: set key_value = to_char(l_new_surrogate_key)
2024: where key_value = to_char(stu_rec.c_surrogate_key)
2025: and key_name = 'BALANCE_TYPE_ID';
2026:

Line 2129: from hr_s_application_ownerships a

2125: into l_null_return
2126: from dual
2127: where exists
2128: (select null
2129: from hr_s_application_ownerships a
2130: , fnd_product_installations b
2131: , fnd_application c
2132: where a.key_name = 'BALANCE_TYPE_ID'
2133: and a.key_value = stu_rec.c_surrogate_key

Line 2145: from hr_s_application_ownerships a

2141: into l_null_return
2142: from dual
2143: where exists
2144: (select null
2145: from hr_s_application_ownerships a
2146: , fnd_product_installations b
2147: , fnd_application c
2148: where a.key_name = 'BALANCE_TYPE_ID'
2149: and a.key_value = stu_rec.c_surrogate_key

Line 2899: update hr_s_application_ownerships

2895:
2896: update /*+NO_INDEX*/ hr_s_dimension_routes
2897: set run_dimension_id = run_dimension_id - 50000000;
2898:
2899: update hr_s_application_ownerships
2900: set key_value = key_value - 50000000
2901: where key_name = 'BALANCE_DIMENSION_ID';
2902:
2903: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 3000: update hr_s_application_ownerships

2996: update hr_s_balance_dimensions
2997: set balance_dimension_id = l_new_surrogate_key
2998: where balance_dimension_id = stu_rec.c_surrogate_key;
2999:
3000: update hr_s_application_ownerships
3001: set key_value = to_char(l_new_surrogate_key)
3002: where key_value = to_char(stu_rec.c_surrogate_key)
3003: and key_name = 'BALANCE_DIMENSION_ID';
3004:

Line 3058: from hr_s_application_ownerships a

3054: into l_null_return
3055: from dual
3056: where exists
3057: (select null
3058: from hr_s_application_ownerships a
3059: , fnd_product_installations b
3060: , fnd_application c
3061: where a.key_name = 'BALANCE_DIMENSION_ID'
3062: and a.key_value = stu_rec.c_surrogate_key

Line 3074: from hr_s_application_ownerships a

3070: into l_null_return
3071: from dual
3072: where exists
3073: (select null
3074: from hr_s_application_ownerships a
3075: , fnd_product_installations b
3076: , fnd_application c
3077: where a.key_name = 'BALANCE_DIMENSION_ID'
3078: and a.key_value = stu_rec.c_surrogate_key

Line 4369: update hr_s_application_ownerships

4365:
4366: update /*+NO_INDEX*/ hr_s_payment_types
4367: set payment_type_id = payment_type_id - 50000000;
4368:
4369: update hr_s_application_ownerships
4370: set key_value = key_value - 50000000
4371: where key_name = 'PAYMENT_TYPE_ID';
4372:
4373: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4462: update hr_s_application_ownerships

4458: update hr_s_payment_types
4459: set payment_type_id = l_new_surrogate_key
4460: where payment_type_id = stu_rec.c_surrogate_key;
4461:
4462: update hr_s_application_ownerships
4463: set key_value = to_char(l_new_surrogate_key)
4464: where key_value = to_char(stu_rec.c_surrogate_key)
4465: and key_name = 'PAYMENT_TYPE_ID';
4466: END update_uid;

Line 4717: update hr_s_application_ownerships

4713:
4714: update /*+NO_INDEX*/ hr_s_user_column_instances_f
4715: set user_row_id = user_row_id - 50000000;
4716:
4717: update hr_s_application_ownerships
4718: set key_value = key_value - 50000000
4719: where key_name = 'USER_ROW_ID';
4720:
4721: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4847: update hr_s_application_ownerships

4843: set user_row_id = l_new_user_row_id
4844: where user_row_id = r_distinct.c_surrogate_key;
4845:
4846:
4847: update hr_s_application_ownerships
4848: set key_value = to_char(l_new_user_row_id)
4849: where key_value = to_char(r_distinct.c_surrogate_key)
4850: and key_name = 'USER_ROW_ID';
4851:

Line 5048: from hr_s_application_ownerships a

5044: into l_null_return
5045: from dual
5046: where exists (
5047: select null
5048: from hr_s_application_ownerships a
5049: , fnd_product_installations b
5050: , fnd_application c
5051: where a.key_name = 'USER_ROW_ID'
5052: and a.key_value = r_distinct.c_surrogate_key

Line 5064: from hr_s_application_ownerships a

5060: into l_null_return
5061: from dual
5062: where exists (
5063: select null
5064: from hr_s_application_ownerships a
5065: , fnd_product_installations b
5066: , fnd_application c
5067: where a.key_name = 'USER_ROW_ID'
5068: and a.key_value = r_distinct.c_surrogate_key

Line 5471: update hr_s_application_ownerships

5467:
5468: update hr_s_monetary_units
5469: set monetary_unit_id = monetary_unit_id - 50000000;
5470:
5471: update hr_s_application_ownerships
5472: set key_value = key_value - 50000000
5473: where key_name = 'MONETARY_UNIT_ID';
5474:
5475: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 5547: update hr_s_application_ownerships

5543: update hr_s_monetary_units
5544: set monetary_unit_id = l_new_surrogate_key
5545: where monetary_unit_id = stu_rec.c_surrogate_key;
5546:
5547: update hr_s_application_ownerships
5548: set key_value = to_char(l_new_surrogate_key)
5549: where key_value = to_char(stu_rec.c_surrogate_key)
5550: and key_name = 'MONETARY_UNIT_ID';
5551:

Line 5605: from hr_s_application_ownerships a

5601: into l_null_return
5602: from dual
5603: where exists
5604: (select null
5605: from hr_s_application_ownerships a
5606: , fnd_product_installations b
5607: , fnd_application c
5608: where a.key_name = 'MONETARY_UNIT_ID'
5609: and a.key_value = stu_rec.c_surrogate_key

Line 6141: update hr_s_application_ownerships

6137: update hr_s_magnetic_blocks
6138: set magnetic_block_id = l_new_surrogate_key
6139: where magnetic_block_id = stu_rec.c_surrogate_key;
6140:
6141: update hr_s_application_ownerships
6142: set key_value = to_char(l_new_surrogate_key)
6143: where key_value = to_char(stu_rec.c_surrogate_key)
6144: and key_name = 'MAGNETIC_BLOCK_ID';
6145: