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