APPS.OKL_COMBI_CASH_APP_RLS_PVT dependencies on OKL_CSH_ALLCT_SRCHS

Line 339: l_seq_num OKL_CSH_ALLCT_SRCHS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;

335: j NUMBER DEFAULT NULL; -- for ttl table count
336: k NUMBER DEFAULT NULL; -- for tmc table count
337:
338: l_cah_id OKL_SRCH_STRM_TYPS.CAH_ID%TYPE DEFAULT NULL;
339: l_seq_num OKL_CSH_ALLCT_SRCHS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
340: l_csh_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE DEFAULT NULL;
341:
342: l_rule_sty_id OKL_SRCH_STRM_TYPS.STY_ID%TYPE DEFAULT NULL;
343: l_add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE DEFAULT NULL;

Line 340: l_csh_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE DEFAULT NULL;

336: k NUMBER DEFAULT NULL; -- for tmc table count
337:
338: l_cah_id OKL_SRCH_STRM_TYPS.CAH_ID%TYPE DEFAULT NULL;
339: l_seq_num OKL_CSH_ALLCT_SRCHS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
340: l_csh_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE DEFAULT NULL;
341:
342: l_rule_sty_id OKL_SRCH_STRM_TYPS.STY_ID%TYPE DEFAULT NULL;
343: l_add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE DEFAULT NULL;
344:

Line 431: FROM okl_csh_allct_srchs

427:
428: -- get search combination rule headers
429: CURSOR c_get_rules IS
430: SELECT id, sequence_number, cash_search_type
431: FROM okl_csh_allct_srchs
432: ORDER BY sequence_number;
433:
434: ----------
435: