DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKC_K_LINES_TL

Line 86: l_asset_number okc_k_lines_tl.name%TYPE default NULL;

82: x_return_status OUT NOCOPY VARCHAR2) is
83:
84: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
85:
86: l_asset_number okc_k_lines_tl.name%TYPE default NULL;
87:
88: ------------------------------------------------------
89: --Cursor to determine if an addon has been deleted
90: --during rebook

Line 99: okc_k_lines_tl clet,

95: from okc_line_styles_b addon_lseb,
96: okc_k_lines_b addon_cleb,
97: okc_line_styles_b model_lseb,
98: okc_k_lines_b model_cleb,
99: okc_k_lines_tl clet,
100: okc_line_styles_b lseb,
101: okc_k_lines_b cleb
102: where
103: addon_cleb.cle_id = model_cleb.id

Line 736: okc_k_lines_tl clet_sub,

732: cleb_asst.id asset_id -- added for subsidy pools enhancement
733: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
734: from okl_subsidies_b subb,
735: okl_k_lines kle_sub,
736: okc_k_lines_tl clet_sub,
737: okc_k_lines_b cleb_sub,
738: okc_line_styles_b lseb_sub,
739: okc_k_lines_tl clet_asst,
740: okc_k_lines_b cleb_asst,

Line 739: okc_k_lines_tl clet_asst,

735: okl_k_lines kle_sub,
736: okc_k_lines_tl clet_sub,
737: okc_k_lines_b cleb_sub,
738: okc_line_styles_b lseb_sub,
739: okc_k_lines_tl clet_asst,
740: okc_k_lines_b cleb_asst,
741: okc_line_styles_b lseb_asst
742: where subb.id = kle_sub.subsidy_id
743: --and nvl(subb.effective_to_date,sysdate)+nvl(subb.expire_after_days,0) < sysdate