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 528: FROM hr_s_application_ownerships ao

524: ,key_value)
525: SELECT distinct ao.key_name
526: ,ao.product_name
527: ,ao.key_value
528: FROM hr_s_application_ownerships ao
529: ,pay_element_classifications pec
530: WHERE pec.legislation_code = 'ZZ'
531: AND ao.key_name = 'CLASSIFICATION_ID'
532: AND TO_NUMBER(ao.key_value) = pec.classification_id

Line 542: FROM hr_s_application_ownerships ao

538: UNION ALL
539: SELECT distinct ao.key_name
540: ,ao.product_name
541: ,ao.key_value
542: FROM hr_s_application_ownerships ao
543: ,pay_balance_types pbt
544: WHERE pbt.legislation_code = 'ZZ'
545: AND ao.key_name = 'BALANCE_TYPE_ID'
546: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id

Line 556: FROM hr_s_application_ownerships ao

552: UNION ALL
553: SELECT distinct ao.key_name
554: ,ao.product_name
555: ,ao.key_value
556: FROM hr_s_application_ownerships ao
557: ,pay_balance_dimensions pbd
558: WHERE pbd.legislation_code ='ZZ'
559: AND ao.key_name = 'BALANCE_DIMENSION_ID'
560: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id

Line 570: FROM hr_s_application_ownerships ao

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

Line 584: FROM hr_s_application_ownerships ao

580: UNION ALL
581: SELECT distinct ao.key_name
582: ,ao.product_name
583: ,ao.key_value
584: FROM hr_s_application_ownerships ao
585: ,ff_routes fr
586: ,pay_balance_dimensions pbd
587: WHERE pbd.legislation_code ='ZZ'
588: AND ao.key_name = 'ROUTE_ID'

Line 714: update hr_s_application_ownerships

710:
711: update /*+NO_INDEX*/ hr_s_status_processing_rules_f
712: set assignment_status_type_id=assignment_status_type_id - 50000000;
713:
714: update hr_s_application_ownerships
715: set key_value = key_value - 50000000
716: where key_name = 'ASSIGNMENT_STATUS_TYPE_ID';
717:
718: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 815: update hr_s_application_ownerships

811: update hr_s_status_processing_rules_f
812: set assignment_status_type_id = l_new_surrogate_key
813: where assignment_status_type_id = stu_rec.c_surrogate_key;
814:
815: update hr_s_application_ownerships
816: set key_value = to_char(l_new_surrogate_key)
817: where key_value = to_char(stu_rec.c_surrogate_key)
818: and key_name = 'ASSIGNMENT_STATUS_TYPE_ID';
819:

Line 879: from hr_s_application_ownerships a

875: into l_null_return
876: from dual
877: where exists (
878: select null
879: from hr_s_application_ownerships a
880: , fnd_product_installations b
881: , fnd_application c
882: where a.key_name = 'ASSIGNMENT_STATUS_TYPE_ID'
883: and a.key_value = l_new_surrogate_key

Line 1646: update hr_s_application_ownerships

1642:
1643: update /*+NO_INDEX*/ hr_s_DEFINED_BALANCES
1644: set balance_type_id = balance_type_id - 50000000;
1645:
1646: update hr_s_application_ownerships
1647: set key_value = key_value - 50000000
1648: where key_name = 'BALANCE_TYPE_ID';
1649:
1650: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 1805: update hr_s_application_ownerships

1801: set base_balance_type_id = l_new_surrogate_key,
1802: new_balance_type_flag = v_new_balance_type_flag
1803: where base_balance_type_id = stu_rec.c_surrogate_key;
1804:
1805: update hr_s_application_ownerships
1806: set key_value = to_char(l_new_surrogate_key)
1807: where key_value = to_char(stu_rec.c_surrogate_key)
1808: and key_name = 'BALANCE_TYPE_ID';
1809:

Line 1912: from hr_s_application_ownerships a

1908: into l_null_return
1909: from dual
1910: where exists
1911: (select null
1912: from hr_s_application_ownerships a
1913: , fnd_product_installations b
1914: , fnd_application c
1915: where a.key_name = 'BALANCE_TYPE_ID'
1916: and a.key_value = stu_rec.c_surrogate_key

Line 1928: from hr_s_application_ownerships a

1924: into l_null_return
1925: from dual
1926: where exists
1927: (select null
1928: from hr_s_application_ownerships a
1929: , fnd_product_installations b
1930: , fnd_application c
1931: where a.key_name = 'BALANCE_TYPE_ID'
1932: and a.key_value = stu_rec.c_surrogate_key

Line 2653: update hr_s_application_ownerships

2649:
2650: update /*+NO_INDEX*/ hr_s_dimension_routes
2651: set run_dimension_id = run_dimension_id - 50000000;
2652:
2653: update hr_s_application_ownerships
2654: set key_value = key_value - 50000000
2655: where key_name = 'BALANCE_DIMENSION_ID';
2656:
2657: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 2754: update hr_s_application_ownerships

2750: update hr_s_balance_dimensions
2751: set balance_dimension_id = l_new_surrogate_key
2752: where balance_dimension_id = stu_rec.c_surrogate_key;
2753:
2754: update hr_s_application_ownerships
2755: set key_value = to_char(l_new_surrogate_key)
2756: where key_value = to_char(stu_rec.c_surrogate_key)
2757: and key_name = 'BALANCE_DIMENSION_ID';
2758:

Line 2812: from hr_s_application_ownerships a

2808: into l_null_return
2809: from dual
2810: where exists
2811: (select null
2812: from hr_s_application_ownerships a
2813: , fnd_product_installations b
2814: , fnd_application c
2815: where a.key_name = 'BALANCE_DIMENSION_ID'
2816: and a.key_value = stu_rec.c_surrogate_key

Line 2828: from hr_s_application_ownerships a

2824: into l_null_return
2825: from dual
2826: where exists
2827: (select null
2828: from hr_s_application_ownerships a
2829: , fnd_product_installations b
2830: , fnd_application c
2831: where a.key_name = 'BALANCE_DIMENSION_ID'
2832: and a.key_value = stu_rec.c_surrogate_key

Line 4122: update hr_s_application_ownerships

4118:
4119: update /*+NO_INDEX*/ hr_s_payment_types
4120: set payment_type_id = payment_type_id - 50000000;
4121:
4122: update hr_s_application_ownerships
4123: set key_value = key_value - 50000000
4124: where key_name = 'PAYMENT_TYPE_ID';
4125:
4126: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4215: update hr_s_application_ownerships

4211: update hr_s_payment_types
4212: set payment_type_id = l_new_surrogate_key
4213: where payment_type_id = stu_rec.c_surrogate_key;
4214:
4215: update hr_s_application_ownerships
4216: set key_value = to_char(l_new_surrogate_key)
4217: where key_value = to_char(stu_rec.c_surrogate_key)
4218: and key_name = 'PAYMENT_TYPE_ID';
4219: END update_uid;

Line 4467: update hr_s_application_ownerships

4463:
4464: update /*+NO_INDEX*/ hr_s_user_column_instances_f
4465: set user_row_id = user_row_id - 50000000;
4466:
4467: update hr_s_application_ownerships
4468: set key_value = key_value - 50000000
4469: where key_name = 'USER_ROW_ID';
4470:
4471: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 4597: update hr_s_application_ownerships

4593: set user_row_id = l_new_user_row_id
4594: where user_row_id = r_distinct.c_surrogate_key;
4595:
4596:
4597: update hr_s_application_ownerships
4598: set key_value = to_char(l_new_user_row_id)
4599: where key_value = to_char(r_distinct.c_surrogate_key)
4600: and key_name = 'USER_ROW_ID';
4601:

Line 4798: from hr_s_application_ownerships a

4794: into l_null_return
4795: from dual
4796: where exists (
4797: select null
4798: from hr_s_application_ownerships a
4799: , fnd_product_installations b
4800: , fnd_application c
4801: where a.key_name = 'USER_ROW_ID'
4802: and a.key_value = r_distinct.c_surrogate_key

Line 4814: from hr_s_application_ownerships a

4810: into l_null_return
4811: from dual
4812: where exists (
4813: select null
4814: from hr_s_application_ownerships a
4815: , fnd_product_installations b
4816: , fnd_application c
4817: where a.key_name = 'USER_ROW_ID'
4818: and a.key_value = r_distinct.c_surrogate_key

Line 5221: update hr_s_application_ownerships

5217:
5218: update hr_s_monetary_units
5219: set monetary_unit_id = monetary_unit_id - 50000000;
5220:
5221: update hr_s_application_ownerships
5222: set key_value = key_value - 50000000
5223: where key_name = 'MONETARY_UNIT_ID';
5224:
5225: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 5297: update hr_s_application_ownerships

5293: update hr_s_monetary_units
5294: set monetary_unit_id = l_new_surrogate_key
5295: where monetary_unit_id = stu_rec.c_surrogate_key;
5296:
5297: update hr_s_application_ownerships
5298: set key_value = to_char(l_new_surrogate_key)
5299: where key_value = to_char(stu_rec.c_surrogate_key)
5300: and key_name = 'MONETARY_UNIT_ID';
5301:

Line 5355: from hr_s_application_ownerships a

5351: into l_null_return
5352: from dual
5353: where exists
5354: (select null
5355: from hr_s_application_ownerships a
5356: , fnd_product_installations b
5357: , fnd_application c
5358: where a.key_name = 'MONETARY_UNIT_ID'
5359: and a.key_value = stu_rec.c_surrogate_key

Line 5891: update hr_s_application_ownerships

5887: update hr_s_magnetic_blocks
5888: set magnetic_block_id = l_new_surrogate_key
5889: where magnetic_block_id = stu_rec.c_surrogate_key;
5890:
5891: update hr_s_application_ownerships
5892: set key_value = to_char(l_new_surrogate_key)
5893: where key_value = to_char(stu_rec.c_surrogate_key)
5894: and key_name = 'MAGNETIC_BLOCK_ID';
5895: