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 521: INSERT INTO hr_application_ownerships

517: hrrunprc_trace_on;
518: hr_utility.trace('enter: zz_leg_rule');
519: hrrunprc_trace_off;
520:
521: INSERT INTO hr_application_ownerships
522: (key_name
523: ,product_name
524: ,key_value)
525: SELECT distinct ao.key_name

Line 534: FROM hr_application_ownerships ao2

530: WHERE pec.legislation_code = 'ZZ'
531: AND ao.key_name = 'CLASSIFICATION_ID'
532: AND TO_NUMBER(ao.key_value) = pec.classification_id
533: AND NOT EXISTS (SELECT null
534: FROM hr_application_ownerships ao2
535: WHERE ao2.key_name = ao.key_name
536: AND ao2.product_name = ao.product_name
537: AND ao2.key_value = ao.key_value)
538: UNION ALL

Line 548: FROM hr_application_ownerships ao2

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
547: AND NOT EXISTS (SELECT null
548: FROM hr_application_ownerships ao2
549: WHERE ao2.key_name = ao.key_name
550: AND ao2.product_name = ao.product_name
551: AND ao2.key_value = ao.key_value)
552: UNION ALL

Line 562: FROM hr_application_ownerships ao2

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
561: AND NOT EXISTS (SELECT null
562: FROM hr_application_ownerships ao2
563: WHERE ao2.key_name = ao.key_name
564: AND ao2.product_name = ao.product_name
565: AND ao2.key_value = ao.key_value)
566: UNION ALL

Line 576: FROM hr_application_ownerships ao2

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
575: AND NOT EXISTS (SELECT null
576: FROM hr_application_ownerships ao2
577: WHERE ao2.key_name = ao.key_name
578: AND ao2.product_name = ao.product_name
579: AND ao2.key_value = ao.key_value)
580: UNION ALL

Line 592: FROM hr_application_ownerships ao2

588: AND ao.key_name = 'ROUTE_ID'
589: AND TO_NUMBER(ao.key_value) = fr.route_id
590: AND fr.route_id = pbd.route_id
591: AND NOT EXISTS (SELECT null
592: FROM hr_application_ownerships ao2
593: WHERE ao2.key_name = ao.key_name
594: AND ao2.product_name = ao.product_name
595: AND ao2.key_value = ao.key_value);
596:

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

844: -- Test ownership of this current row
845:
846: BEGIN
847: -- This routine only operates in phase 1. Rows are present in the
848: -- table hr_application_ownerships in the delivery account, which
849: -- dictate which products a piece of data is used for. If the query
850: -- returns a row, then this data is required, and the function will
851: -- return true. If no rows are returned and an exception is raised,
852: -- then this row is not required and may be deleted from the delivery

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

5320:
5321: BEGIN
5322:
5323: -- This routine only operates in phase 1. Rows are present in the
5324: -- table hr_application_ownerships in the delivery account, which
5325: -- dictate which products a piece of data is used for. If the query
5326: -- returns a row then this data is required, and the function will
5327: -- return true. If no rows are returned and an exception is raised,
5328: -- then this row is not required and may be deleted from the delivery