APPS.OKS_MASSCHANGE_PVT dependencies on OKC_K_HEADERS_V

Line 55: l_from :=' FROM okc_k_headers_v okh,okc_k_party_roles_b okp,okx_parties_v oxp, hr_operating_units org,okc_assents_v oas

51: oxp.name party
52: ,org.name
53: ,okh.billed_at_source';
54:
55: l_from :=' FROM okc_k_headers_v okh,okc_k_party_roles_b okp,okx_parties_v oxp, hr_operating_units org,okc_assents_v oas
56: , okc_k_lines_b ocl';
57:
58: If p_ctr_rec.attribute in ('CONTRACT_START_DATE','CONTRACT_END_DATE') Then
59: IF p_ctr_rec.oie_id IS NOT NULL THEN

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 1239: -- 'AND EXISTS (SELECT id from okc_k_headers_v a

1235: AND okh.id = to_number(:update_level_value)';
1236: --/*
1237: -- l_stmt := l_select||' ,NULL old_value'||
1238: -- l_from||l_where||
1239: -- 'AND EXISTS (SELECT id from okc_k_headers_v a
1240: -- WHERE a.id = okh.id
1241: -- MINUS
1242: -- SELECT okg.included_chr_id
1243: -- FROM okc_k_groups_grpings_v okg

Line 3675: l_where||' AND EXISTS (SELECT id from okc_k_headers_v a

3671: AND okp1.object1_id1 = :update_level_value';
3672: /*
3673: l_stmt := l_select||' ,NULL old_value'||
3674: l_from||',okc_k_party_roles_b okp1'||
3675: l_where||' AND EXISTS (SELECT id from okc_k_headers_v a
3676: WHERE a.id = okh.id
3677: MINUS
3678: SELECT okg.included_chr_id
3679: FROM okc_k_groups_grpings_v okg

Line 4802: l_where||' AND EXISTS (SELECT id from okc_k_headers_v a

4798: AND okh.scs_code = :update_level_value';
4799:
4800: /* l_stmt := l_select||' ,NULL old_value'||
4801: l_from||
4802: l_where||' AND EXISTS (SELECT id from okc_k_headers_v a
4803: WHERE a.id = okh.id
4804: MINUS
4805: SELECT okg.included_chr_id
4806: FROM okc_k_groups_grpings_v okg

Line 6181: l_where||' AND EXISTS (SELECT id from okc_k_headers_v a

6177: CONNECT BY okg1.cgp_parent_id = PRIOR okg1.included_cgp_id)';
6178: /*
6179: l_stmt := l_select||' ,NULL old_value'||
6180: l_from||
6181: l_where||' AND EXISTS (SELECT id from okc_k_headers_v a
6182: WHERE a.id = okh.id
6183: MINUS
6184: SELECT okg.included_chr_id
6185: FROM okc_k_groups_grpings_v okg

Line 7039: FROM okc_k_headers_v okh,

7035: ole.id ole_id,
7036: mrd.old_value,
7037: okh.billed_at_source
7038:
7039: FROM okc_k_headers_v okh,
7040: okc_operation_lines_v ole,
7041: okc_masschange_req_dtls_v mrd
7042: WHERE ole.select_yn = 'Y'
7043: AND ole.process_flag is NULL

Line 7614: SELECT estimated_amount FROM okc_k_headers_v WHERE id = p_chr_id;

7610: FUNCTION Get_contract_amount(p_chr_id IN Number)
7611: RETURN Number IS
7612: l_cont_amt Number;
7613: CURSOR Get_amt IS
7614: SELECT estimated_amount FROM okc_k_headers_v WHERE id = p_chr_id;
7615: BEGIN
7616: OPEN Get_amt;
7617: FETCH Get_amt INTO l_cont_amt;
7618: CLOSE Get_amt;