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 2559: FROM okl_k_headers_full_v

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

Line 2566: OKL_K_HEADERS KHR

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

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

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

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

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

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

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

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

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

Line 2733: FROM okl_k_headers_full_v

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

Line 2740: OKL_K_HEADERS KHR

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

Line 4645: FROM okl_k_headers_full_v CHR

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

Line 4663: okl_k_headers khr

4659: -- cursor when only customer and program is selected
4660: 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
4661: SELECT CHR.id
4662: FROM okc_k_headers_b CHR,
4663: okl_k_headers khr
4664: , okc_k_party_roles_b prl
4665: WHERE chr.id = khr.id
4666: AND prl.dnz_chr_id = CHR.id
4667: AND prl.chr_id = CHR.id

Line 4683: okl_k_headers khr

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

Line 4703: okl_k_headers khr

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

Line 4716: okl_k_headers khr

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

Line 4735: FROM okl_k_headers_full_v CHR

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

Line 4744: FROM okl_k_headers_full_v chr

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

Line 4755: FROM okl_k_headers_full_v CHR

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

Line 4772: FROM okl_k_headers_full_v CHR

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

Line 4832: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;

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

Line 5759: from OKL_k_headers_full_V

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

Line 5783: from OKL_k_headers_full_V prg_hdr

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

Line 5799: FROM okl_k_headers_full_v

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

Line 5804: FROM okl_k_headers_full_V

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

Line 6555: FROM okl_k_headers_full_v

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

Line 6625: okl_k_headers khr

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

Line 6645: l_template_type_code okl_k_headers.template_type_code%type;

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

Line 8094: FROM okl_k_headers_full_v

8090: -- orig_system_id1,
8091: currency_code,
8092: pdt_id,
8093: khr_id
8094: FROM okl_k_headers_full_v
8095: WHERE id = p_durv_rec.chr_id;
8096:
8097:
8098: CURSOR l_vers_version_csr IS

Line 8105: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8101: WHERE vers.chr_id = p_durv_rec.chr_id;
8102:
8103: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8104: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8105: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8106: WHERE mla.id = gvr.chr_id_referred
8107: AND mla.scs_code = p_scs_code -- mla or cl
8108: AND gvr.chr_id = p_durv_rec.chr_id
8109: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8158: FROM okl_k_headers_full_v

8154: WHERE currency_code = p_currency_code;
8155:
8156: CURSOR l_program_csr(program_id NUMBER) IS
8157: SELECT id,contract_number
8158: FROM okl_k_headers_full_v
8159: WHERE id = program_id;
8160:
8161: CURSOR l_contact_csr IS
8162: --Start modified abhsaxen for performance SQLID 20563327