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_CREAT_PVT dependencies on OKL_K_HEADERS

Line 266: -- FUNCTION get_rec for: OKL_K_HEADERS_V

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

Line 272: CURSOR okl_k_headers_v_pk_csr (p_id IN NUMBER) IS

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

Line 335: FROM OKL_K_HEADERS_V

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

Line 336: WHERE OKL_K_HEADERS_V.id = p_id;

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

Line 337: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

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

Line 343: OPEN okl_k_headers_v_pk_csr (p_khrv_rec.id);

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

Line 344: FETCH okl_k_headers_v_pk_csr INTO

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

Line 407: x_no_data_found := okl_k_headers_v_pk_csr%NOTFOUND;

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

Line 408: CLOSE okl_k_headers_v_pk_csr;

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

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

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

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

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

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

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

Line 451: FROM okl_k_headers khr,

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

Line 1153: FROM okl_k_headers_full_v

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

Line 1218: l_khr_id okl_k_headers.khr_id%type;

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

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

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

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

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

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

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

Line 2553: FROM okl_k_headers_full_v

2549:
2550: --Cursor to get vp template
2551: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2552: SELECT id
2553: FROM okl_k_headers_full_v
2554: WHERE scs_code = 'PROGRAM'
2555: AND sts_code IN ('ACTIVE','PASSED')
2556: AND khr_id = p_vp_id
2557: AND NVL(template_yn,'N') = 'Y';

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

2696: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2697: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2698: l_start_date okc_k_headers_b.start_date%TYPE;
2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2701: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2702: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2703: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2704: x_converted_amount NUMBER := NULL;

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

2697: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2698: l_start_date okc_k_headers_b.start_date%TYPE;
2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2701: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2702: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2703: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2704: x_converted_amount NUMBER := NULL;
2705:

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

2698: l_start_date okc_k_headers_b.start_date%TYPE;
2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2701: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2702: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2703: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2704: x_converted_amount NUMBER := NULL;
2705:
2706: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

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

2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2701: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2702: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2703: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2704: x_converted_amount NUMBER := NULL;
2705:
2706: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2707: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;

Line 2718: FROM okl_k_headers_full_v

2714:
2715: --Cursor to get vp template
2716: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2717: SELECT id
2718: FROM okl_k_headers_full_v
2719: WHERE scs_code = 'PROGRAM'
2720: AND sts_code IN ('ACTIVE','PASSED')
2721: AND khr_id = p_vp_id
2722: AND NVL(template_yn,'N') = 'Y';

Line 4623: FROM okl_k_headers_full_v CHR

4619: -- cursor when only customer is selected
4620:
4621: CURSOR l_leaseAppTmpl1_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4622: SELECT CHR.id
4623: FROM okl_k_headers_full_v CHR
4624: , okc_k_party_roles_b prl
4625: WHERE prl.dnz_chr_id = CHR.id
4626: AND prl.chr_id = CHR.id
4627: AND CHR.scs_code = 'LEASE'

Line 4641: okl_k_headers khr

4637: -- cursor when only customer and program is selected
4638: 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
4639: SELECT CHR.id
4640: FROM okc_k_headers_b CHR,
4641: okl_k_headers khr
4642: , okc_k_party_roles_b prl
4643: WHERE chr.id = khr.id
4644: AND prl.dnz_chr_id = CHR.id
4645: AND prl.chr_id = CHR.id

Line 4661: okl_k_headers khr

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

Line 4681: okl_k_headers khr

4677: -- cursor when only program is selected
4678: CURSOR l_source_prog_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, l_prog_id NUMBER) IS
4679: SELECT CHR.id
4680: FROM okc_k_headers_b CHR,
4681: okl_k_headers khr
4682: WHERE chr.id = khr.id
4683: AND CHR.scs_code = p_scs_code
4684: AND CHR.chr_type = 'CYA'
4685: AND NVL(CHR.template_yn,'N') = p_temp_yn

Line 4694: okl_k_headers khr

4690: -- cursor when only program is selected
4691: CURSOR l_leaseAppTmpl3_crs(l_prog_id NUMBER) IS
4692: SELECT CHR.id
4693: FROM okc_k_headers_b CHR,
4694: okl_k_headers khr
4695: WHERE chr.id = khr.id
4696: AND CHR.scs_code = 'LEASE'
4697: AND CHR.chr_type = 'CYA'
4698: AND NVL(CHR.template_yn,'N') = 'Y'

Line 4713: FROM okl_k_headers_full_v CHR

4709: AND CHR.contract_number = p_source_contract_number;
4710:
4711: CURSOR l_leaseAppTmpl_crs IS
4712: SELECT CHR.id
4713: FROM okl_k_headers_full_v CHR
4714: WHERE CHR.scs_code = 'LEASE'
4715: AND CHR.chr_type = 'CYA'
4716: AND nvl(CHR.template_yn,'N') = 'Y'
4717: AND NVL(CHR.TEMPLATE_TYPE_CODE,'XXX') = 'LEASEAPP'

Line 4722: FROM okl_k_headers_full_v chr

4718: AND CHR.contract_number = p_source_contract_number;
4719:
4720: CURSOR l_program_csr IS
4721: SELECT chr.id
4722: FROM okl_k_headers_full_v chr
4723: WHERE chr.scs_code = 'PROGRAM'
4724: AND nvl(chr.template_yn, 'N') = 'N'
4725: AND chr.sts_code = 'ACTIVE'
4726: AND chr.authoring_org_id = p_org_id

Line 4733: FROM okl_k_headers_full_v CHR

4729: AND chr.contract_number = p_program_name;
4730:
4731: CURSOR l_progAgrmntTemp_crs(p_prog_id NUMBER) IS
4732: SELECT CHR.id
4733: FROM okl_k_headers_full_v CHR
4734: WHERE CHR.scs_code = p_scs_code
4735: AND CHR.chr_type = 'CYA'
4736: AND nvl(chr.template_yn,'N') = 'Y'
4737: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 4750: FROM okl_k_headers_full_v CHR

4746: */
4747:
4748: CURSOR l_progAgrmntTemp1_crs IS
4749: SELECT CHR.id
4750: FROM okl_k_headers_full_v CHR
4751: WHERE CHR.scs_code = p_scs_code
4752: AND CHR.chr_type = 'CYA'
4753: AND nvl(chr.template_yn,'N') = 'Y'
4754: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 4810: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;

4806: FROM OKL_LEASE_APPLICATIONS_B
4807: WHERE PARENT_LEASEAPP_ID = LAP.ID
4808: AND APPLICATION_STATUS NOT IN ('WITHDRAWN' , 'CR-REJECTED'));
4809:
4810: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4811: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4812: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4814: l_object_code VARCHAR2(30) DEFAULT NULL;

Line 5857: from OKL_k_headers_full_V

5853: l_rbr_code okl_trx_contracts.rbr_code%type := null;
5854:
5855: cursor l_mla_csr is
5856: select id
5857: from OKL_k_headers_full_V
5858: where contract_number = p_mla_no
5859: and scs_code = 'MASTER_LEASE'
5860: and STS_CODE = 'ACTIVE'
5861: and TEMPLATE_YN = 'N'

Line 5881: from OKL_k_headers_full_V prg_hdr

5877: l_cl_id NUMBER;
5878:
5879: cursor l_program_csr is
5880: select id
5881: from OKL_k_headers_full_V prg_hdr
5882: where contract_number = p_program_no
5883: and scs_code = 'PROGRAM'
5884: and nvl(TEMPLATE_YN, 'N') = 'N'
5885: and sts_code = 'ACTIVE'

Line 5897: FROM okl_k_headers_full_v

5893: old_khr_id NUMBER;
5894:
5895: CURSOR c_vp_exsts_csr IS
5896: SELECT khr_id
5897: FROM okl_k_headers_full_v
5898: WHERE id = p_chr_id;
5899:
5900: CURSOR c_context_csr IS
5901: SELECT authoring_org_id, inv_organization_id

Line 5902: FROM okl_k_headers_full_V

5898: WHERE id = p_chr_id;
5899:
5900: CURSOR c_context_csr IS
5901: SELECT authoring_org_id, inv_organization_id
5902: FROM okl_k_headers_full_V
5903: WHERE id = p_chr_id;
5904:
5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

Line 6672: FROM okl_k_headers_full_v

6668: old_khr_id NUMBER;
6669:
6670: CURSOR c_vp_exsts_csr IS
6671: SELECT khr_id
6672: FROM okl_k_headers_full_v
6673: WHERE id = p_durv_rec.chr_id;
6674:
6675: l_fin_ast VARCHAR2(1) := 'N';
6676: l_lrls_yn VARCHAR2(1) := 'X';

Line 6741: okl_k_headers khr

6737: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6738: SELECT chrb.template_yn,
6739: khr.template_type_code
6740: FROM okc_k_headers_b chrb,
6741: okl_k_headers khr
6742: WHERE chrb.id = khr.id
6743: AND chrb.id = p_chr_id;
6744:
6745: CURSOR l_pqcl_csr IS

Line 6767: l_template_type_code okl_k_headers.template_type_code%type;

6763: FROM okc_k_party_roles_b
6764: WHERE dnz_chr_id = p_chr_id
6765: AND rle_code ='LESSOR';
6766:
6767: l_template_type_code okl_k_headers.template_type_code%type;
6768: l_ptemplate_yn okc_k_headers_b.template_yn%type;
6769:
6770: CURSOR c_orig_pdt_csr(p_chr_id IN NUMBER) IS
6771: SELECT pdt_id

Line 6772: FROM okl_k_headers

6768: l_ptemplate_yn okc_k_headers_b.template_yn%type;
6769:
6770: CURSOR c_orig_pdt_csr(p_chr_id IN NUMBER) IS
6771: SELECT pdt_id
6772: FROM okl_k_headers
6773: WHERE id = p_chr_id;
6774:
6775: l_orig_pdt_rec c_orig_pdt_csr%ROWTYPE;
6776:

Line 8289: FROM okl_k_headers_full_v

8285: -- orig_system_id1,
8286: currency_code,
8287: pdt_id,
8288: khr_id
8289: FROM okl_k_headers_full_v
8290: WHERE id = p_durv_rec.chr_id;
8291:
8292:
8293: CURSOR l_vers_version_csr IS

Line 8300: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8296: WHERE vers.chr_id = p_durv_rec.chr_id;
8297:
8298: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8299: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8300: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8301: WHERE mla.id = gvr.chr_id_referred
8302: AND mla.scs_code = p_scs_code -- mla or cl
8303: AND gvr.chr_id = p_durv_rec.chr_id
8304: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8353: FROM okl_k_headers_full_v

8349: WHERE currency_code = p_currency_code;
8350:
8351: CURSOR l_program_csr(program_id NUMBER) IS
8352: SELECT id,contract_number
8353: FROM okl_k_headers_full_v
8354: WHERE id = program_id;
8355:
8356: CURSOR l_contact_csr IS
8357: --Start modified abhsaxen for performance SQLID 20563327

Line 8944: FROM okl_k_headers_full_v

8940: l_hdr_uv_rec c_hdr_full_uv%ROWTYPE;
8941:
8942: CURSOR c_hdr_full_v(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
8943: SELECT *
8944: FROM okl_k_headers_full_v
8945: WHERE id = p_chr_id;
8946:
8947: l_hdr_rec c_hdr_full_v%ROWTYPE;
8948:

Line 8963: FROM okl_k_headers_full_v mla,

8959: CURSOR c_gvr_data(p_scs_code VARCHAR2,
8960: p_chr_id NUMBER,
8961: p_dnz_chr_id NUMBER) IS
8962: SELECT mla.contract_number,gvr.chr_id_referred,gvr.id
8963: FROM okl_k_headers_full_v mla,
8964: okc_governances_v gvr
8965: WHERE mla.id = gvr.chr_id_referred
8966: AND mla.scs_code = p_scs_code
8967: AND gvr.dnz_chr_id = p_dnz_chr_id

Line 9017: FROM okl_k_headers_full_v chr

9013: AND lsq.status = 'CT-ACCEPTED';
9014:
9015: CURSOR c_program_template_name(p_orig_system_id1 NUMBER, p_khr_khr_id NUMBER) IS
9016: SELECT chr.contract_number
9017: FROM okl_k_headers_full_v chr
9018: WHERE chr.id = p_orig_system_id1
9019: AND chr.template_type_code = 'PROGRAM'
9020: AND NVL(chr.template_yn,'N') = 'Y'
9021: AND EXISTS(SELECT 1