[Home] [Help]
1419: -- -1 PROGRAM_LOGIN_ID,
1420: sysdate PROGRAM_UPDATE_DATE
1421:
1422: FROM
1423: OKC_K_HEADERS_ALL_B chr,
1424: OKL_K_HEADERS khr,
1425: okl_parallel_processes opp,
1426: HR_OPERATING_UNITS hr_org,
1427: OKC_STATUSES_B status,
2001: FA_BOOKS FB,
2002: FA_ADDITIONS_B FA,
2003: FA_METHODS FM,
2004: okc_k_lines_b cle,
2005: okc_k_headers_all_b chr,
2006: okl_system_params_all sys_param,
2007: OKC_K_ITEMS item
2008: WHERE
2009: ITEM.cle_id = cle.id
2051: FA_BOOKS FB,
2052: FA_ADDITIONS_B FA,
2053: FA_METHODS FM,
2054: okc_k_lines_b cle,
2055: okc_k_headers_all_b chr,
2056: okl_system_params_all sys_param,
2057: OKC_K_ITEMS item
2058: WHERE
2059: ITEM.cle_id = cle.id
3534: -- -1 PROGRAM_LOGIN_ID,
3535: sysdate PROGRAM_UPDATE_DATE
3536:
3537: FROM
3538: OKC_K_HEADERS_ALL_B chr,
3539: OKL_K_HEADERS khr,
3540: okl_parallel_processes opp,
3541: HR_OPERATING_UNITS hr_org,
3542: OKC_STATUSES_B status,
4083: FROM
4084: okc_k_lines_b cleb_fa,
4085: OKL_TXd_assets_b okl_asset,
4086: okl_txl_assets_b okl_asset_l,
4087: okc_k_headers_all_b chr,
4088: okl_system_params_all sys_param,
4089: fa_book_controls fbc,
4090: fa_methods fm
4091: where
4117: FROM
4118: okc_k_lines_b cleb_fa,
4119: OKL_TXd_assets_b okl_asset_d,
4120: okl_txl_assets_b okl_asset_l,
4121: okc_k_headers_all_b chr,
4122: okl_system_params_all sys_param,
4123: fa_book_controls fbc,
4124: fa_methods fm
4125: where
5559: -- -1 PROGRAM_LOGIN_ID,
5560: sysdate PROGRAM_UPDATE_DATE
5561:
5562: FROM
5563: OKC_K_HEADERS_ALL_B chr,
5564: OKL_K_HEADERS khr,
5565: okl_parallel_processes opp,
5566: HR_OPERATING_UNITS hr_org,
5567: OKC_STATUSES_B status,
6592: ----------------------------------------------------------------------------------------------------
6593:
6594: FUNCTION Contract_Active_YN (p_chr_id IN OKL_K_HEADERS.ID%TYPE,
6595: p_deal_type IN OKL_K_HEADERS.DEAL_TYPE%TYPE,
6596: p_sts_code IN okc_k_headers_all_b.STS_CODE%TYPE)
6597: return VARCHAR2
6598: IS
6599:
6600: l_active_contract BOOLEAN := FALSE;