eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_K_HEADERS

Line 267: -- FUNCTION get_rec for: OKL_K_HEADERS_V

263: RETURN(get_rec(p_chrv_rec, l_row_notfound));
264:
265: END get_rec;
266: ---------------------------------------------------------------------------
267: -- FUNCTION get_rec for: OKL_K_HEADERS_V
268: ---------------------------------------------------------------------------
269: FUNCTION get_rec (
270: p_khrv_rec IN khrv_rec_type,
271: x_no_data_found OUT NOCOPY BOOLEAN

Line 273: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS

269: FUNCTION get_rec (
270: p_khrv_rec IN khrv_rec_type,
271: x_no_data_found OUT NOCOPY BOOLEAN
272: ) RETURN khrv_rec_type IS
273: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS
274: SELECT
275: ID,
276: OBJECT_VERSION_NUMBER,
277: ISG_ID,

Line 336: FROM OKL_K_HEADERS_V

332: CURRENCY_CONVERSION_RATE,
333: CURRENCY_CONVERSION_DATE,
334: CURRENCY_CONVERSION_TYPE,
335: ASSIGNABLE_YN
336: FROM OKL_K_HEADERS_V
337: WHERE OKL_K_HEADERS_V.id = p_id;
338: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
339: l_khrv_rec khrv_rec_type;
340: BEGIN

Line 337: WHERE OKL_K_HEADERS_V.id = p_id;

333: CURRENCY_CONVERSION_DATE,
334: CURRENCY_CONVERSION_TYPE,
335: ASSIGNABLE_YN
336: FROM OKL_K_HEADERS_V
337: WHERE OKL_K_HEADERS_V.id = p_id;
338: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
339: l_khrv_rec khrv_rec_type;
340: BEGIN
341:

Line 338: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

334: CURRENCY_CONVERSION_TYPE,
335: ASSIGNABLE_YN
336: FROM OKL_K_HEADERS_V
337: WHERE OKL_K_HEADERS_V.id = p_id;
338: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
339: l_khrv_rec khrv_rec_type;
340: BEGIN
341:
342: x_no_data_found := TRUE;

Line 344: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);

340: BEGIN
341:
342: x_no_data_found := TRUE;
343: -- Get current database values
344: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
345: FETCH okl_k_headers_v_pk_csr INTO
346: l_khrv_rec.ID,
347: l_khrv_rec.OBJECT_VERSION_NUMBER,
348: l_khrv_rec.ISG_ID,

Line 345: FETCH okl_k_headers_v_pk_csr INTO

341:
342: x_no_data_found := TRUE;
343: -- Get current database values
344: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);
345: FETCH okl_k_headers_v_pk_csr INTO
346: l_khrv_rec.ID,
347: l_khrv_rec.OBJECT_VERSION_NUMBER,
348: l_khrv_rec.ISG_ID,
349: l_khrv_rec.KHR_ID,

Line 408: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;

404: l_khrv_rec.CURRENCY_CONVERSION_DATE,
405: l_khrv_rec.CURRENCY_CONVERSION_TYPE,
406: l_khrv_rec.ASSIGNABLE_YN
407: ;
408: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
409: CLOSE okl_k_headers_v_pk_csr;
410: RETURN(l_khrv_rec);
411: END get_rec;
412:

Line 409: CLOSE okl_k_headers_v_pk_csr;

405: l_khrv_rec.CURRENCY_CONVERSION_TYPE,
406: l_khrv_rec.ASSIGNABLE_YN
407: ;
408: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;
409: CLOSE okl_k_headers_v_pk_csr;
410: RETURN(l_khrv_rec);
411: END get_rec;
412:
413: FUNCTION get_rec (

Line 439: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;

435: p_contract_number IN VARCHAR2,
436: p_source_chr_id IN NUMBER,
437: x_chr_id OUT NOCOPY NUMBER) AS
438:
439: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
440: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
441: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
442:
443: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 440: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;

436: p_source_chr_id IN NUMBER,
437: x_chr_id OUT NOCOPY NUMBER) AS
438:
439: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
440: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
441: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
442:
443: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 441: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;

437: x_chr_id OUT NOCOPY NUMBER) AS
438:
439: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
440: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
441: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
442:
443: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
445: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 452: FROM okl_k_headers khr,

448: CURSOR get_k_start_date_and_term_csr(l_chr_id NUMBER) IS
449: -- START: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938
450: --SELECT ADD_MONTHS(start_date,term_duration)-1
451: SELECT chr.start_date, khr.term_duration
452: FROM okl_k_headers khr,
453: okc_k_headers_b chr
454: WHERE khr.id = chr.id
455: AND chr.id = l_chr_id;
456: -- START: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938

Line 1154: FROM okl_k_headers_full_v

1150: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1151:
1152: CURSOR get_curr_csr(p_id IN NUMBER) IS
1153: SELECT id,currency_code,currency_conversion_type,currency_conversion_date,currency_conversion_rate, cust_acct_id, khr_id
1154: FROM okl_k_headers_full_v
1155: WHERE scs_code = 'QUOTE'
1156: AND id = p_id;
1157:
1158: CURSOR c_rgpv IS

Line 1219: l_khr_id okl_k_headers.khr_id%type;

1215: AND lse.lse_type = 'TLS'
1216: AND lse.lse_parent_id IS NULL;
1217:
1218: l_cust_acct_id okc_k_headers_b.cust_acct_id%type;
1219: l_khr_id okl_k_headers.khr_id%type;
1220:
1221: l_chr_id NUMBER;
1222: l_rgp_id NUMBER;
1223: l_cpl_id NUMBER;

Line 1237: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;

1233: l_line_tab okl_copy_asset_pub.klev_tbl_type;
1234: x_cle_id_tbl okl_copy_asset_pub.klev_tbl_type;
1235:
1236: l_currency_code okc_k_headers_b.currency_code%TYPE := NULL;
1237: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;
1238: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1239: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1240:
1241: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 1238: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;

1234: x_cle_id_tbl okl_copy_asset_pub.klev_tbl_type;
1235:
1236: l_currency_code okc_k_headers_b.currency_code%TYPE := NULL;
1237: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;
1238: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1239: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1240:
1241: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1242: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;

Line 1239: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;

1235:
1236: l_currency_code okc_k_headers_b.currency_code%TYPE := NULL;
1237: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;
1238: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1239: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1240:
1241: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1242: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
1243:

Line 2556: FROM okl_k_headers_full_v

2552: --Cursor to get vp template
2553: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2554: /* Modified this query to improve performance for bug#6979120
2555: SELECT id
2556: FROM okl_k_headers_full_v
2557: WHERE scs_code = 'PROGRAM'
2558: AND sts_code IN ('ACTIVE','PASSED')
2559: AND khr_id = p_vp_id
2560: AND NVL(template_yn,'N') = 'Y'; */

Line 2563: OKL_K_HEADERS KHR

2559: AND khr_id = p_vp_id
2560: AND NVL(template_yn,'N') = 'Y'; */
2561: SELECT CHRB.ID ID
2562: FROM OKC_K_HEADERS_ALL_B CHRB,
2563: OKL_K_HEADERS KHR
2564: WHERE CHRB.SCS_CODE = 'PROGRAM'
2565: AND CHRB.ID = KHR.ID
2566: AND CHRB.STS_CODE IN ('ACTIVE', 'PASSED')
2567: AND CHRB.TEMPLATE_YN = 'Y'

Line 2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;

2707: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2708: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2709: l_start_date okc_k_headers_b.start_date%TYPE;
2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2714: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2715: x_converted_amount NUMBER := NULL;

Line 2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;

2708: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2709: l_start_date okc_k_headers_b.start_date%TYPE;
2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2714: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2715: x_converted_amount NUMBER := NULL;
2716:

Line 2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;

2709: l_start_date okc_k_headers_b.start_date%TYPE;
2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2714: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2715: x_converted_amount NUMBER := NULL;
2716:
2717: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

Line 2714: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;

2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2714: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2715: x_converted_amount NUMBER := NULL;
2716:
2717: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2718: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;

Line 2730: FROM okl_k_headers_full_v

2726: --Cursor to get vp template
2727: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2728: /* Modified this query to improve performance for bug#6979120
2729: SELECT id
2730: FROM okl_k_headers_full_v
2731: WHERE scs_code = 'PROGRAM'
2732: AND sts_code IN ('ACTIVE','PASSED')
2733: AND khr_id = p_vp_id
2734: AND NVL(template_yn,'N') = 'Y'; */

Line 2737: OKL_K_HEADERS KHR

2733: AND khr_id = p_vp_id
2734: AND NVL(template_yn,'N') = 'Y'; */
2735: SELECT CHRB.ID ID
2736: FROM OKC_K_HEADERS_ALL_B CHRB,
2737: OKL_K_HEADERS KHR
2738: WHERE CHRB.SCS_CODE = 'PROGRAM'
2739: AND CHRB.ID = KHR.ID
2740: AND CHRB.STS_CODE IN ('ACTIVE', 'PASSED')
2741: AND CHRB.TEMPLATE_YN = 'Y'

Line 4642: FROM okl_k_headers_full_v CHR

4638: -- cursor when only customer is selected
4639:
4640: CURSOR l_leaseAppTmpl1_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4641: SELECT CHR.id
4642: FROM okl_k_headers_full_v CHR
4643: , okc_k_party_roles_b prl
4644: WHERE prl.dnz_chr_id = CHR.id
4645: AND prl.chr_id = CHR.id
4646: AND CHR.scs_code = 'LEASE'

Line 4660: okl_k_headers khr

4656: -- cursor when only customer and program is selected
4657: CURSOR l_source_chr_prog_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4658: SELECT CHR.id
4659: FROM okc_k_headers_b CHR,
4660: okl_k_headers khr
4661: , okc_k_party_roles_b prl
4662: WHERE chr.id = khr.id
4663: AND prl.dnz_chr_id = CHR.id
4664: AND prl.chr_id = CHR.id

Line 4680: okl_k_headers khr

4676: -- cursor when only customer and program is selected
4677: CURSOR l_leaseAppTmpl2_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4678: SELECT CHR.id
4679: FROM okc_k_headers_b CHR,
4680: okl_k_headers khr
4681: , okc_k_party_roles_b prl
4682: WHERE chr.id = khr.id
4683: AND prl.dnz_chr_id = CHR.id
4684: AND prl.chr_id = CHR.id

Line 4700: okl_k_headers khr

4696: -- cursor when only program is selected
4697: CURSOR l_source_prog_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, l_prog_id NUMBER) IS
4698: SELECT CHR.id
4699: FROM okc_k_headers_b CHR,
4700: okl_k_headers khr
4701: WHERE chr.id = khr.id
4702: AND CHR.scs_code = p_scs_code
4703: AND CHR.chr_type = 'CYA'
4704: AND NVL(CHR.template_yn,'N') = p_temp_yn

Line 4713: okl_k_headers khr

4709: -- cursor when only program is selected
4710: CURSOR l_leaseAppTmpl3_crs(l_prog_id NUMBER) IS
4711: SELECT CHR.id
4712: FROM okc_k_headers_b CHR,
4713: okl_k_headers khr
4714: WHERE chr.id = khr.id
4715: AND CHR.scs_code = 'LEASE'
4716: AND CHR.chr_type = 'CYA'
4717: AND NVL(CHR.template_yn,'N') = 'Y'

Line 4732: FROM okl_k_headers_full_v CHR

4728: AND CHR.contract_number = p_source_contract_number;
4729:
4730: CURSOR l_leaseAppTmpl_crs IS
4731: SELECT CHR.id
4732: FROM okl_k_headers_full_v CHR
4733: WHERE CHR.scs_code = 'LEASE'
4734: AND CHR.chr_type = 'CYA'
4735: AND nvl(CHR.template_yn,'N') = 'Y'
4736: AND NVL(CHR.TEMPLATE_TYPE_CODE,'XXX') = 'LEASEAPP'

Line 4741: FROM okl_k_headers_full_v chr

4737: AND CHR.contract_number = p_source_contract_number;
4738:
4739: CURSOR l_program_csr IS
4740: SELECT chr.id
4741: FROM okl_k_headers_full_v chr
4742: WHERE chr.scs_code = 'PROGRAM'
4743: AND nvl(chr.template_yn, 'N') = 'N'
4744: AND chr.sts_code = 'ACTIVE'
4745: AND chr.authoring_org_id = p_org_id

Line 4752: FROM okl_k_headers_full_v CHR

4748: AND chr.contract_number = p_program_name;
4749:
4750: CURSOR l_progAgrmntTemp_crs(p_prog_id NUMBER) IS
4751: SELECT CHR.id
4752: FROM okl_k_headers_full_v CHR
4753: WHERE CHR.scs_code = p_scs_code
4754: AND CHR.chr_type = 'CYA'
4755: AND nvl(chr.template_yn,'N') = 'Y'
4756: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 4769: FROM okl_k_headers_full_v CHR

4765: */
4766:
4767: CURSOR l_progAgrmntTemp1_crs IS
4768: SELECT CHR.id
4769: FROM okl_k_headers_full_v CHR
4770: WHERE CHR.scs_code = p_scs_code
4771: AND CHR.chr_type = 'CYA'
4772: AND nvl(chr.template_yn,'N') = 'Y'
4773: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 4829: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;

4825: and application_status not in ('WITHDRAWN' , 'CR-REJECTED'))
4826: ;
4827: --end changed by abhsaxen for Bug#6174484
4828:
4829: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4830: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4831: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4832: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4833: l_object_code VARCHAR2(30) DEFAULT NULL;

Line 5756: from OKL_k_headers_full_V

5752: l_rbr_code okl_trx_contracts.rbr_code%type := null;
5753:
5754: cursor l_mla_csr is
5755: select id
5756: from OKL_k_headers_full_V
5757: where contract_number = p_mla_no
5758: and scs_code = 'MASTER_LEASE'
5759: and STS_CODE = 'ACTIVE'
5760: and TEMPLATE_YN = 'N'

Line 5780: from OKL_k_headers_full_V prg_hdr

5776: l_cl_id NUMBER;
5777:
5778: cursor l_program_csr is
5779: select id
5780: from OKL_k_headers_full_V prg_hdr
5781: where contract_number = p_program_no
5782: and scs_code = 'PROGRAM'
5783: and nvl(TEMPLATE_YN, 'N') = 'N'
5784: and sts_code = 'ACTIVE'

Line 5796: FROM okl_k_headers_full_v

5792: old_khr_id NUMBER;
5793:
5794: CURSOR c_vp_exsts_csr IS
5795: SELECT khr_id
5796: FROM okl_k_headers_full_v
5797: WHERE id = p_chr_id;
5798:
5799: CURSOR c_context_csr IS
5800: SELECT authoring_org_id, inv_organization_id

Line 5801: FROM okl_k_headers_full_V

5797: WHERE id = p_chr_id;
5798:
5799: CURSOR c_context_csr IS
5800: SELECT authoring_org_id, inv_organization_id
5801: FROM okl_k_headers_full_V
5802: WHERE id = p_chr_id;
5803:
5804: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5805: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

Line 6552: FROM okl_k_headers_full_v

6548: old_khr_id NUMBER;
6549:
6550: CURSOR c_vp_exsts_csr IS
6551: SELECT khr_id
6552: FROM okl_k_headers_full_v
6553: WHERE id = p_durv_rec.chr_id;
6554:
6555: l_fin_ast VARCHAR2(1) := 'N';
6556: l_lrls_yn VARCHAR2(1) := 'X';

Line 6622: okl_k_headers khr

6618: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6619: SELECT chrb.template_yn,
6620: khr.template_type_code
6621: FROM okc_k_headers_b chrb,
6622: okl_k_headers khr
6623: WHERE chrb.id = khr.id
6624: AND chrb.id = p_chr_id;
6625:
6626: CURSOR l_pqcl_csr IS

Line 6642: l_template_type_code okl_k_headers.template_type_code%type;

6638: WHERE qclv.Id = qcl.id
6639: AND UPPER(qcl.name) = 'OKL KT FOR LA QA CHECKLIST'
6640: AND qcl.LANGUAGE = 'US';
6641:
6642: l_template_type_code okl_k_headers.template_type_code%type;
6643: l_ptemplate_yn okc_k_headers_b.template_yn%type;
6644:
6645: /*
6646: -- mvasudev, 08/18/2004

Line 8085: FROM okl_k_headers_full_v

8081: -- orig_system_id1,
8082: currency_code,
8083: pdt_id,
8084: khr_id
8085: FROM okl_k_headers_full_v
8086: WHERE id = p_durv_rec.chr_id;
8087:
8088:
8089: CURSOR l_vers_version_csr IS

Line 8096: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8092: WHERE vers.chr_id = p_durv_rec.chr_id;
8093:
8094: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8095: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8096: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8097: WHERE mla.id = gvr.chr_id_referred
8098: AND mla.scs_code = p_scs_code -- mla or cl
8099: AND gvr.chr_id = p_durv_rec.chr_id
8100: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8149: FROM okl_k_headers_full_v

8145: WHERE currency_code = p_currency_code;
8146:
8147: CURSOR l_program_csr(program_id NUMBER) IS
8148: SELECT id,contract_number
8149: FROM okl_k_headers_full_v
8150: WHERE id = program_id;
8151:
8152: CURSOR l_contact_csr IS
8153: --Start modified abhsaxen for performance SQLID 20563327