APPS.OKE_FORM_DD250 dependencies on OKC_ANCESTRYS

Line 684: from okc_ancestrys

680: , pr.facility
681: FROM okc_k_party_roles_b pr
682: , oke_k_deliverables_b kd
683: , ( select cle_id , cle_id_ascendant , level_sequence
684: from okc_ancestrys
685: union all
686: select id , id , 99999 from okc_k_lines_b ) a
687: WHERE kd.deliverable_id = C_Deliverable_ID
688: AND pr.rle_code = C_Role_Code

Line 708: from okc_ancestrys

704: SELECT pr.code
705: FROM okc_k_party_roles_b pr
706: , oke_k_deliverables_b kd
707: , ( select cle_id , cle_id_ascendant , level_sequence
708: from okc_ancestrys
709: union all
710: select id , id , 99999 from okc_k_lines_b ) a
711: WHERE kd.deliverable_id = C_Deliverable_ID
712: AND pr.rle_code = C_Role_Code

Line 735: from okc_ancestrys

731: , pr.facility
732: FROM okc_k_party_roles_b pr
733: , oke_k_deliverables_b kd
734: , ( select cle_id , cle_id_ascendant , level_sequence
735: from okc_ancestrys
736: union all
737: select id , id , 99999 from okc_k_lines_b ) a
738: WHERE kd.deliverable_id = C_Deliverable_ID
739: AND pr.rle_code = C_Role_Code

Line 759: from okc_ancestrys

755: SELECT pr.code
756: FROM okc_k_party_roles_b pr
757: , oke_k_deliverables_b kd
758: , ( select cle_id , cle_id_ascendant , level_sequence
759: from okc_ancestrys
760: union all
761: select id , id , 99999 from okc_k_lines_b ) a
762: WHERE kd.deliverable_id = C_Deliverable_ID
763: AND pr.rle_code = C_Role_Code

Line 785: from okc_ancestrys

781: , kt.term_value_pk2 , 'MEANING' ) Name
782: FROM oke_k_terms kt
783: , oke_k_deliverables_b kd
784: , ( select cle_id , cle_id_ascendant , level_sequence
785: from okc_ancestrys
786: union all
787: select id , id , 99999 from okc_k_lines_b ) a
788: WHERE kd.deliverable_id = C_Deliverable_ID
789: AND kt.term_code = C_Term_Code