DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_STRM_TYPE_B

Line 1157: and rl.object1_id1=(select id from okl_strm_type_b where code='RENT');

1153: and rg.cle_id = c_line_id
1154: and rg.rgd_code = 'LALEVL'
1155: and rl.rule_information_category = 'LASLH'
1156: and rl.dnz_chr_id = c_khr_id
1157: and rl.object1_id1=(select id from okl_strm_type_b where code='RENT');
1158:
1159: CURSOR c_get_freq_arr(c_line_id NUMBER,c_khr_id NUMBER,c_rent_slh_id NUMBER)
1160: IS
1161: select rl.object1_id1 frequency

Line 3737: FROM okl_strm_type_tl styt, okl_strm_type_b sty

3733: FUNCTION get_sty_id (p_sty_name IN VARCHAR2) RETURN NUMBER IS
3734:
3735: CURSOR c_sty IS
3736: SELECT sty.id
3737: FROM okl_strm_type_tl styt, okl_strm_type_b sty
3738: WHERE styt.name = p_sty_name
3739: AND styt.language = 'US'
3740: AND sty.id = styt.id
3741: AND sty.start_date <= TRUNC(SYSDATE)