DBA Data[Home] [Help]

APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_K_HEADERS_ALL_B

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

1014:
1015: -- check if the contract has been imported and fully billed at source or not
1016:
1017: IF(l_chr_id IS NOT NULL) THEN
1018: select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;
1019: END IF;
1020:
1021: IF ((l_bill_y_n IS NOT NULL) AND (l_bill_y_n = 'Y')) THEN
1022: l_disp_warning :='Y';

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

4744: l_clev_tbl_in.DELETE;
4745:
4746: -- check if the contract has been imported and fully billed at source
4747: IF(l_chr_id IS NOT NULL) THEN
4748: select billed_at_source INTO l_bill_y_n FROM okc_k_headers_all_b where id = l_chr_id ;
4749: END IF;
4750:
4751: IF ((l_bill_y_n IS NOT NULL) AND (l_bill_y_n = 'Y')) THEN
4752: l_disp_warning :='Y';