APPS.OKE_VERSION_COMPARISON_PKG dependencies on OKE_K_DELIVERABLES_BH

Line 2903: from oke_k_deliverables_bh

2899:
2900: If L_Latest_Version >= vVersion1 THEN
2901: SELECT count(*)
2902: INTO nDeliverables
2903: from oke_k_deliverables_bh
2904: where k_header_id=vHeader_id
2905: and k_line_id=nCurrent_line_id
2906: and major_version=vVersion1;
2907:

Line 4486: from oke_k_deliverables_bh

4482:
4483: IF L_Latest_Version >= vVersion1 THEN
4484: SELECT count(*)
4485: INTO nDeliverables
4486: from oke_k_deliverables_bh
4487: where k_header_id=vHeader_id
4488: and k_line_id=nCurrent_line_id
4489: AND MAJOR_VERSION=vVersion1;
4490:

Line 5377: from oke_k_deliverables_bh

5373: current_deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE;
5374:
5375: CURSOR c_deliverables_2 IS
5376: SELECT deliverable_id
5377: from oke_k_deliverables_bh
5378: where k_header_id=vHeader_id
5379: and k_line_id=vCurrentLineId
5380: and major_version=vVersion2
5381: ORDER BY deliverable_num;

Line 5486: from oke_k_deliverables_bh

5482:
5483: IF L_Latest_Version >= vVersion1 THEN
5484: OPEN v_deliverables_1 FOR
5485: SELECT deliverable_id
5486: from oke_k_deliverables_bh
5487: where k_header_id=vHeader_id
5488: and k_line_id=vCurrentLineId
5489: and major_version=vVersion1
5490: ORDER BY deliverable_num;

Line 5519: from oke_k_deliverables_bh

5515: IF L_Latest_Version >= vVersion1 THEN
5516:
5517: SELECT deliverable_num
5518: INTO current_deliverable_num
5519: from oke_k_deliverables_bh
5520: where k_header_id=vHeader_id
5521: and k_line_id=vCurrentLineId
5522: and major_version=vVersion1
5523: and deliverable_id=current_deliverable_1;

Line 6583: from oke_k_deliverables_bh

6579: l_data2 := '';
6580:
6581: SELECT deliverable_num
6582: INTO current_deliverable_num
6583: from oke_k_deliverables_bh
6584: where k_header_id=vHeader_id
6585: and k_line_id=vCurrentLineId
6586: and major_version=vVersion2
6587: and deliverable_id=c_deliverable_2.deliverable_id;