DBA Data[Home] [Help]

APPS.OKL_SIX_PVT dependencies on FND_LOOKUPS

Line 539: FROM fnd_lookups

535:
536: -- start: cklee 07/07/2005
537: CURSOR c_get_trx_type_code_csr IS
538: SELECT 'X'
539: FROM fnd_lookups
540: WHERE lookup_type = 'OKL_SUB_POOL_LINE_TYPE'
541: AND lookup_code = p_trx_type_code;
542: lv_dummy VARCHAR2(1) := 'N';
543: -- end: cklee 07/07/2005

Line 591: FROM fnd_lookups

587:
588: -- start: cklee 07/07/2005
589: CURSOR c_get_source_type_csr IS
590: SELECT 'X'
591: FROM fnd_lookups
592: WHERE lookup_type = 'OKL_SUB_POOL_TRX_SOURCE_TYPE'
593: AND lookup_code = p_source_type_code;
594: lv_dummy VARCHAR2(1) := 'N';
595: -- end: cklee 07/07/2005

Line 695: FROM fnd_lookups

691: p_trx_reason_code IN VARCHAR2) IS
692:
693: CURSOR c_get_trx_reason_csr IS
694: SELECT 'X'
695: FROM fnd_lookups
696: WHERE lookup_type = 'OKL_SUB_POOL_TRX_REASON_TYPE'
697: AND lookup_code = p_trx_reason_code;
698: lv_dummy VARCHAR2(1);
699: BEGIN