DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on OKC_SUBCLASSES_V

Line 2479: l_scs_code okc_subclasses_v.code%type;

2475: CURSOR cur_startend(p_chr_id number) is
2476: select start_date,end_date from okc_k_headers_b where
2477: id=p_chr_id;
2478:
2479: l_scs_code okc_subclasses_v.code%type;
2480: l_cls_code okc_subclasses_v.cls_code%type;
2481: l_k_status_code okc_k_headers_v.sts_code%type;
2482: l_end_date date;
2483: l_start_date date;

Line 2480: l_cls_code okc_subclasses_v.cls_code%type;

2476: select start_date,end_date from okc_k_headers_b where
2477: id=p_chr_id;
2478:
2479: l_scs_code okc_subclasses_v.code%type;
2480: l_cls_code okc_subclasses_v.cls_code%type;
2481: l_k_status_code okc_k_headers_v.sts_code%type;
2482: l_end_date date;
2483: l_start_date date;
2484: l_estimated_amount number;