APPS.OKE_VERSION_COMPARISON_PKG dependencies on OKE_K_DELIVERABLES_B

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 2917: from oke_k_deliverables_b

2913:
2914: ELSE
2915: SELECT count(*)
2916: INTO nDeliverables
2917: from oke_k_deliverables_b
2918: where k_header_id=vHeader_id
2919: and k_line_id=nCurrent_line_id;
2920:
2921: SELECT count(*)

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 4501: from oke_k_deliverables_b

4497:
4498: ELSE
4499: SELECT count(*)
4500: INTO nDeliverables
4501: from oke_k_deliverables_b
4502: where k_header_id=vHeader_id
4503: and k_line_id=nCurrent_line_id;
4504:
4505: SELECT count(*)

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 5494: from oke_k_deliverables_b

5490: ORDER BY deliverable_num;
5491: ELSE
5492: OPEN v_deliverables_1 FOR
5493: SELECT deliverable_id
5494: from oke_k_deliverables_b
5495: where k_header_id=vHeader_id
5496: and k_line_id=vCurrentLineId
5497: ORDER BY deliverable_num;
5498: END IF;

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 5530: from oke_k_deliverables_b

5526: ELSE
5527:
5528: SELECT deliverable_num
5529: INTO current_deliverable_num
5530: from oke_k_deliverables_b
5531: where k_header_id=vHeader_id
5532: and k_line_id=vCurrentLineId
5533: and deliverable_id=current_deliverable_1;
5534:

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;