DBA Data[Home] [Help]

APPS.PAY_PAP_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 561: FROM pay_element_types_f pet

557: -- Checks the format of the input value and fetches the element type.
558: --
559: CURSOR csr_chk_input_value IS
560: SELECT pet.element_type_id
561: FROM pay_element_types_f pet
562: ,pay_input_values_f piv
563: WHERE piv.input_value_id = p_pto_input_value_id
564: AND (piv.business_group_id = p_business_group_id
565: OR (piv.business_group_id is null

Line 580: FROM pay_element_types_f pet

576: -- The UOM is again validated, but this time against the absence type's UOM.
577: --
578: CURSOR csr_chk_pet_and_paat IS
579: SELECT null
580: FROM pay_element_types_f pet
581: ,pay_element_classifications pec
582: WHERE pet.element_type_id = l_element_type_id
583: AND pet.classification_id = pec.classification_id
584: AND (pet.processing_type = 'N'