DBA Data[Home] [Help]

APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 1012: select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;

1008:
1009: -- check if the contract has been imported and fully billed at source or not
1010:
1011: IF(l_chr_id IS NOT NULL) THEN
1012: select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;
1013: END IF;
1014:
1015: IF ((l_bill_y_n IS NOT NULL) AND (l_bill_y_n = 'Y')) THEN
1016: l_disp_warning :='Y';

Line 4649: select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;

4645: l_clev_tbl_in.DELETE;
4646:
4647: -- check if the contract has been imported and fully billed at source
4648: IF(l_chr_id IS NOT NULL) THEN
4649: select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;
4650: END IF;
4651:
4652: IF ((l_bill_y_n IS NOT NULL) AND (l_bill_y_n = 'Y')) THEN
4653: l_disp_warning :='Y';