APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_K_HEADERS

Line 2192: FROM OKC_K_HEADERS_B A, OKL_K_HEADERS B WHERE

2188: -- bug
2189: A.AUTHORING_ORG_ID,
2190: A.CURRENCY_CODE,
2191: B.DEAL_TYPE -- Bug 4887014
2192: FROM OKC_K_HEADERS_B A, OKL_K_HEADERS B WHERE
2193: A.ID = P_CHR_ID
2194: AND A.ID = B.ID;
2195:
2196: --Changed query for performance --dkagrawa

Line 2239: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

2235: -- added for bug 5115701 - end
2236: l_invalid_line varchar2(1) := 'N';
2237:
2238: l_chr_rec CHR_DTLS_CSR%ROWTYPE;
2239: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
2240:
2241: -- R12B Authoring OA Migration
2242: l_upfront_tax_pymt_yn VARCHAR2(1);
2243:

Line 2829: l_term okl_k_headers.term_duration%TYPE;

2825: l_pym_hdr_rec PYM_HDR_REC_TYPE;
2826: l_pym_tbl PYM_TBL_TYPE;
2827:
2828: l_flag VARCHAR2(1) := 'N';
2829: l_term okl_k_headers.term_duration%TYPE;
2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

Line 2842: *FROM OKC_RULES_B IVAR, OKC_RULES_B INTP, OKC_RULE_GROUPS_B RG, OKL_K_HEADERS K

2838:
2839: /*
2840: *CURSOR VIR_PAYMENT (P_CHR_ID IN NUMBER) IS
2841: *SELECT 'Y', K.TERM_DURATION
2842: *FROM OKC_RULES_B IVAR, OKC_RULES_B INTP, OKC_RULE_GROUPS_B RG, OKL_K_HEADERS K
2843: *WHERE
2844: *IVAR.RULE_INFORMATION_CATEGORY = 'LAIVAR' AND IVAR.RULE_INFORMATION1 = 'FLOAT' AND
2845: *INTP.RULE_INFORMATION_CATEGORY = 'LAINTP' AND INTP.RULE_INFORMATION1 = 'Y' AND
2846: *RG.ID = IVAR.RGP_ID AND RG.RGD_CODE = 'LAIIND' AND RG.ID = INTP.RGP_ID

Line 2860: OKL_K_HEADERS K

2856: OKC_RULES_B IVAR,
2857: OKC_RULES_B INTP,
2858: OKC_RULES_B ICLC,
2859: OKC_RULE_GROUPS_B RG,
2860: OKL_K_HEADERS K
2861: WHERE
2862: IVAR.RULE_INFORMATION_CATEGORY = 'LAIVAR'
2863: AND INTP.RULE_INFORMATION_CATEGORY = 'LAINTP'
2864: AND ICLC.RULE_INFORMATION_CATEGORY = 'LAICLC'

Line 2875: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

2871: AND K.ID = P_CHR_ID
2872: AND RG.DNZ_CHR_ID = P_CHR_ID
2873: AND RG.CHR_ID = P_CHR_ID;
2874:
2875: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2876: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;
2877: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;
2878: l_data_found BOOLEAN;
2879:

Line 3655: FROM OKL_K_HEADERS

3651:
3652: FUNCTION get_term(p_id IN NUMBER) RETURN NUMBER IS
3653: CURSOR contract_csr(p_contract_id NUMBER) IS
3654: SELECT TERM_DURATION
3655: FROM OKL_K_HEADERS
3656: WHERE ID = p_contract_id;
3657: begin
3658: for r IN contract_csr(p_id)
3659: LOOP

Line 3687: l_term okl_k_headers.term_duration%TYPE;

3683: l_payment_id NUMBER;
3684: l_pym_hdr_rec PYM_HDR_REC_TYPE;
3685: l_pym_tbl PYM_TBL_TYPE;
3686:
3687: l_term okl_k_headers.term_duration%TYPE;
3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

Line 3696: l_deal_type OKL_K_HEADERS.deal_type%TYPE;

3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3695:
3696: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
3697: l_interest_calculation_basis VARCHAR2(30);
3698: l_revenue_recognition_method VARCHAR2(30);
3699: l_data_found BOOLEAN;
3700: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;