APPS.PAY_RCU_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 395: -- pay_element_types_f.

391: --
392: -- Description:
393: -- Validates the combination of creator type and creator id.
394: -- When creator type is ET, then the creator id should be exist in
395: -- pay_element_types_f.
396: -- When creator type is EC, then the creator id should be exist in
397: -- pay_element_classifications.
398: --
399: -- Prerequisites:

Line 445: from pay_element_types_f

441: -- Cursor to check that an element type exists.
442: --
443: cursor csr_element_type is
444: select null
445: from pay_element_types_f
446: where element_type_id = p_creator_id
447: and p_effective_date between effective_start_date
448: and effective_end_date
449: and nvl(legislation_code, nvl(l_legislation_code, l_varchar2))

Line 510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');

506: if csr_element_type%notfound then
507: close csr_element_type;
508:
509: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
511: fnd_message.set_token('COLUMN','ELEMENT_TYPE_ID');
512: fnd_message.raise_error;
513:
514: end if;