APPS.HR_LEGISLATION dependencies on HR_APPLICATION_OWNERSHIPS

Line 138: -- hr_application_ownerships table, in

134: -- not cater for core and legislation
135: -- balances clashing.
136: -- 110.8 A.Mills 17/02/99 Added to_chars around surrogate id's
137: -- for comparison and entry into the
138: -- hr_application_ownerships table, in
139: -- response to ZA install problem.
140: -- 110.9 A.Mills 05-Mar-1999 Changed implicit cursors to explicit
141: -- cursors, due to implicit cursor's
142: -- 'select into null where exists'

Line 726: INSERT INTO hr_application_ownerships

722: hrrunprc_trace_on;
723: hr_utility.trace('enter: zz_leg_rule');
724: hrrunprc_trace_off;
725:
726: INSERT INTO hr_application_ownerships
727: (key_name
728: ,product_name
729: ,key_value)
730: SELECT distinct ao.key_name

Line 739: FROM hr_application_ownerships ao2

735: WHERE pec.legislation_code = 'ZZ'
736: AND ao.key_name = 'CLASSIFICATION_ID'
737: AND TO_NUMBER(ao.key_value) = pec.classification_id
738: AND NOT EXISTS (SELECT null
739: FROM hr_application_ownerships ao2
740: WHERE ao2.key_name = ao.key_name
741: AND ao2.product_name = ao.product_name
742: AND ao2.key_value = ao.key_value)
743: UNION ALL

Line 753: FROM hr_application_ownerships ao2

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
752: AND NOT EXISTS (SELECT null
753: FROM hr_application_ownerships ao2
754: WHERE ao2.key_name = ao.key_name
755: AND ao2.product_name = ao.product_name
756: AND ao2.key_value = ao.key_value)
757: UNION ALL

Line 767: FROM hr_application_ownerships ao2

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
766: AND NOT EXISTS (SELECT null
767: FROM hr_application_ownerships ao2
768: WHERE ao2.key_name = ao.key_name
769: AND ao2.product_name = ao.product_name
770: AND ao2.key_value = ao.key_value)
771: UNION ALL

Line 781: FROM hr_application_ownerships ao2

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
781: FROM hr_application_ownerships ao2
782: WHERE ao2.key_name = ao.key_name
783: AND ao2.product_name = ao.product_name
784: AND ao2.key_value = ao.key_value)
785: UNION ALL

Line 797: FROM hr_application_ownerships ao2

793: AND ao.key_name = 'ROUTE_ID'
794: AND TO_NUMBER(ao.key_value) = fr.route_id
795: AND fr.route_id = pbd.route_id
796: AND NOT EXISTS (SELECT null
797: FROM hr_application_ownerships ao2
798: WHERE ao2.key_name = ao.key_name
799: AND ao2.product_name = ao.product_name
800: AND ao2.key_value = ao.key_value);
801:

Line 1053: -- table hr_application_ownerships in the delivery account, which

1049: -- Test ownership of this current row
1050:
1051: BEGIN
1052: -- This routine only operates in phase 1. Rows are present in the
1053: -- table hr_application_ownerships in the delivery account, which
1054: -- dictate which products a piece of data is used for. If the query
1055: -- returns a row, then this data is required, and the function will
1056: -- return true. If no rows are returned and an exception is raised,
1057: -- then this row is not required and may be deleted from the delivery

Line 5574: -- table hr_application_ownerships in the delivery account, which

5570:
5571: BEGIN
5572:
5573: -- This routine only operates in phase 1. Rows are present in the
5574: -- table hr_application_ownerships in the delivery account, which
5575: -- dictate which products a piece of data is used for. If the query
5576: -- returns a row then this data is required, and the function will
5577: -- return true. If no rows are returned and an exception is raised,
5578: -- then this row is not required and may be deleted from the delivery