APPS.PAY_IP_STARTUP_UTIL dependencies on HR_APPLICATION_OWNERSHIPS

Line 705: FROM hr_application_ownerships ao

701: ,key_value)
702: SELECT ao.key_name
703: ,ao.product_name
704: ,ao.key_value
705: FROM hr_application_ownerships ao
706: ,pay_element_classifications pec
707: WHERE pec.legislation_code = 'ZZ'
708: AND ao.key_name = 'CLASSIFICATION_ID'
709: AND TO_NUMBER(ao.key_value) = pec.classification_id

Line 714: FROM hr_application_ownerships ao

710: UNION ALL
711: SELECT ao.key_name
712: ,ao.product_name
713: ,ao.key_value
714: FROM hr_application_ownerships ao
715: ,pay_balance_types pbt
716: WHERE pbt.legislation_code = 'ZZ'
717: AND ao.key_name = 'BALANCE_TYPE_ID'
718: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id

Line 723: FROM hr_application_ownerships ao

719: UNION ALL
720: SELECT ao.key_name
721: ,ao.product_name
722: ,ao.key_value
723: FROM hr_application_ownerships ao
724: ,pay_balance_dimensions pbd
725: WHERE pbd.legislation_code ='ZZ'
726: AND ao.key_name = 'BALANCE_DIMENSION_ID'
727: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id

Line 732: FROM hr_application_ownerships ao

728: UNION ALL
729: SELECT ao.key_name
730: ,ao.product_name
731: ,ao.key_value
732: FROM hr_application_ownerships ao
733: ,pay_defined_balances pdb
734: WHERE pdb.legislation_code ='ZZ'
735: AND ao.key_name = 'DEFINED_BALANCE_ID'
736: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id

Line 741: FROM hr_application_ownerships ao

737: UNION ALL
738: SELECT ao.key_name
739: ,ao.product_name
740: ,ao.key_value
741: FROM hr_application_ownerships ao
742: ,ff_routes fr
743: ,pay_balance_dimensions pbd
744: WHERE pbd.legislation_code ='ZZ'
745: AND ao.key_name = 'ROUTE_ID'