DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on HR_GENERAL

Line 206: l_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');--'Archive Reference Number';

202: FETCH csr_arch_ref_no INTO l_arch_ref_no_check;
203: CLOSE csr_arch_ref_no;
204: IF l_arch_ref_no_check = 1 THEN
205: l_token_name(1) := 'NUMBER_CATEGORY';
206: l_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','ARCH_REF_NUM');--'Archive Reference Number';
207: RAISE E_NON_UNIQUE_ARCH_REF_NO;
208: END IF;
209:
210: SELECT TRUNC(effective_date)