APPS.OKS_MASSCHANGE_PVT dependencies on OKS_MSCHG_OPERATIONS_DTLS

Line 159: l_from :=' FROM okc_k_headers_v okh,okc_operation_lines_v ole ,oks_mschg_operations_dtls mod, hr_operating_units org';

155: mod.qa_check_yn,
156: org.name ,
157: okh.billed_at_source';
158:
159: l_from :=' FROM okc_k_headers_v okh,okc_operation_lines_v ole ,oks_mschg_operations_dtls mod, hr_operating_units org';
160: l_where:=' WHERE ole.select_yn = ''Y''
161: AND ole.process_flag IN (''A'',''E'')
162: AND okh.id = ole.subject_chr_id
163: AND ole.oie_id = :p_ctr_rec_oie_id

Line 13231: from oks_mschg_operations_dtls mcd

13227: RAISE OKC_API.G_EXCEPTION_ERROR;
13228: END IF;
13229:
13230: Select mcd.id , mcd.mrd_id into p_mod_id ,p_mod_mrd_id
13231: from oks_mschg_operations_dtls mcd
13232: where mcd.ole_id = p_ole_id ;
13233:
13234: l_mod_tbl_in.id := p_mod_id;
13235: l_mod_tbl_in.qa_check_yn := p_qa_check_yn ; --:OKSOIE_LINES.qa_check_yn;