DBA Data[Home] [Help]

APPS.CE_PURGE_TRX_CODES_XML dependencies on CE_LOOKUPS

Line 62: FROM ce_lookups LKP

58: --bank account type
59: IF p_acct_type IS NOT NULL
60: THEN
61: SELECT substr(LKP.meaning,0,50) INTO g_account_type
62: FROM ce_lookups LKP
63: WHERE LKP.lookup_type = 'BANK_ACCOUNT_TYPE'
64: AND LKP.lookup_code = p_acct_type;
65: ElSE
66: g_account_type := NULL;

Line 74: FROM ce_lookups LKP

70: --Process option
71: IF p_process_option IS NOT NULL
72: THEN
73: SELECT substr(LKP.meaning,0,50) INTO g_process_option
74: FROM ce_lookups LKP
75: WHERE LKP.lookup_type = 'PURGE_TXCD_PROCESS_OPTION'
76: AND LKP.lookup_code = p_process_option;
77: ELSE
78: g_process_option := NULL;