APPS.PAY_RCU_BUS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 397: -- pay_element_classifications.

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:
400: -- None.
401: --

Line 459: from pay_element_classifications

455: -- Cursor to check that an element classification exists.
456: --
457: cursor csr_classification is
458: select null
459: from pay_element_classifications
460: where classification_id = p_creator_id
461: and nvl(legislation_code, nvl(l_legislation_code, l_varchar2))
462: = nvl(l_legislation_code, l_varchar2)
463: and nvl(business_group_id, nvl(p_business_group_id, l_number))

Line 529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');

525: if csr_classification%notfound then
526: close csr_classification;
527:
528: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');
530: fnd_message.set_token('COLUMN','CLASSIFICATION_ID');
531: fnd_message.raise_error;
532:
533: end if;