[Home] [Help]
808: ,key_value)
809: SELECT ao.key_name
810: ,ao.product_name
811: ,ao.key_value
812: FROM hr_application_ownerships ao
813: ,pay_element_classifications pec
814: WHERE pec.legislation_code = 'ZZ'
815: AND ao.key_name = 'CLASSIFICATION_ID'
816: AND TO_NUMBER(ao.key_value) = pec.classification_id
817: UNION ALL
818: SELECT ao.key_name
819: ,ao.product_name
820: ,ao.key_value
821: FROM hr_application_ownerships ao
822: ,pay_balance_types pbt
823: WHERE pbt.legislation_code = 'ZZ'
824: AND ao.key_name = 'BALANCE_TYPE_ID'
825: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
826: UNION ALL
827: SELECT ao.key_name
828: ,ao.product_name
829: ,ao.key_value
830: FROM hr_application_ownerships ao
831: ,pay_balance_dimensions pbd
832: WHERE pbd.legislation_code ='ZZ'
833: AND ao.key_name = 'BALANCE_DIMENSION_ID'
834: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
835: UNION ALL
836: SELECT ao.key_name
837: ,ao.product_name
838: ,ao.key_value
839: FROM hr_application_ownerships ao
840: ,pay_defined_balances pdb
841: WHERE pdb.legislation_code ='ZZ'
842: AND ao.key_name = 'DEFINED_BALANCE_ID'
843: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id
844: UNION ALL
845: SELECT ao.key_name
846: ,ao.product_name
847: ,ao.key_value
848: FROM hr_application_ownerships ao
849: ,ff_routes fr
850: ,pay_balance_dimensions pbd
851: WHERE pbd.legislation_code ='ZZ'
852: AND ao.key_name = 'ROUTE_ID'
855: UNION ALL
856: SELECT ao.key_name
857: ,ao.product_name
858: ,ao.key_value
859: FROM hr_application_ownerships ao
860: ,ff_routes fr
861: ,pay_balance_dimensions pbd
862: ,pay_dimension_routes pdr
863: WHERE pbd.legislation_code ='ZZ'
868: UNION ALL
869: SELECT ao.key_name
870: ,ao.product_name
871: ,ao.key_value
872: FROM hr_application_ownerships ao,
873: pay_balance_categories pbc
874: WHERE pbc.legislation_code ='ZZ'
875: AND ao.key_name = 'BALANCE_CATEGORY_ID'
876: AND TO_NUMBER(ao.key_value) = pbc.balance_category_id;