DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_K_HEADERS_ALL_BH

Line 5597: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_BH';

5593: P_Num_Workers in number)
5594: IS
5595: l_worker_id number;
5596: l_product varchar2(30) := 'OKC';
5597: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_BH';
5598: l_update_name varchar2(30) := 'OKCLNUPH_CP';
5599: l_status varchar2(30);
5600: l_industry varchar2(30);
5601: l_retstatus boolean;

Line 5661: from okc_k_headers_all_bh hdr,

5657: / (trunc (months_between (cle.end_date, cle.start_date) / 12) + 1)
5658: / (cle.end_date - cle.start_date + 1)
5659: ELSE cle.annualized_factor
5660: end new_annualized_factor
5661: from okc_k_headers_all_bh hdr,
5662: okc_k_lines_bh cle
5663: where hdr.rowid between l_start_rowid and l_end_rowid
5664: and hdr.id = cle.dnz_chr_id
5665: and hdr.major_version = cle.major_version