eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AUTO_REMINDER dependencies on OKC_STATUSES_B

Line 662: okc_statuses_b s

658: -- bug 5161013 check STE_CODE for the contract
659: CURSOR csr_k_ste_code IS
660: SELECT s.ste_code
661: FROM okc_k_headers_all_b k,
662: okc_statuses_b s
663: WHERE k.sts_code = s.code
664: AND k.id = p_chr_id;
665:
666: l_ste_code okc_statuses_b.ste_code%TYPE;

Line 666: l_ste_code okc_statuses_b.ste_code%TYPE;

662: okc_statuses_b s
663: WHERE k.sts_code = s.code
664: AND k.id = p_chr_id;
665:
666: l_ste_code okc_statuses_b.ste_code%TYPE;
667:
668: BEGIN
669: -- bug 5161013
670: -- check if the STE_CODE of the contract is ENTERED and only then update the status

Line 738: SELECT STE_CODE INTO lcode FROM okc_statuses_b WHERE code = pcode;

734: FUNCTION GET_STATUS(pcode IN VARCHAR2) RETURN VARCHAR2
735: IS
736: lcode VARCHAR2(40);
737: BEGIN
738: SELECT STE_CODE INTO lcode FROM okc_statuses_b WHERE code = pcode;
739: RETURN lcode;
740: EXCEPTION
741: WHEN OTHERS THEN
742: RETURN pcode;