DBA Data[Home] [Help]

APPS.PAY_PAP_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 587: FROM pay_element_types_f pet

583: -- Checks the format of the input value and fetches the element type.
584: --
585: CURSOR csr_chk_input_value IS
586: SELECT pet.element_type_id
587: FROM pay_element_types_f pet
588: ,pay_input_values_f piv
589: WHERE piv.input_value_id = p_pto_input_value_id
590: AND (piv.business_group_id = p_business_group_id
591: OR (piv.business_group_id is null

Line 606: FROM pay_element_types_f pet

602: -- The UOM is again validated, but this time against the absence type's UOM.
603: --
604: CURSOR csr_chk_pet_and_paat IS
605: SELECT null
606: FROM pay_element_types_f pet
607: ,pay_element_classifications pec
608: WHERE pet.element_type_id = l_element_type_id
609: AND pet.classification_id = pec.classification_id
610: AND (pet.processing_type = 'N'