DBA Data[Home] [Help]

APPS.PAY_PPR_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 673: from pay_element_types_f element, pay_element_classifications classif,

669:
670: Cursor c_chk_element_type
671: is
672: select null
673: from pay_element_types_f element, pay_element_classifications classif,
674: pay_element_classifications_tl classif_tl, pay_element_types_f_tl element_tl
675: where classif_tl.classification_id = classif.classification_id
676: and classif_tl.language = userenv('LANG')
677: and element.Element_type_id = element_tl.Element_type_id

Line 674: pay_element_classifications_tl classif_tl, pay_element_types_f_tl element_tl

670: Cursor c_chk_element_type
671: is
672: select null
673: from pay_element_types_f element, pay_element_classifications classif,
674: pay_element_classifications_tl classif_tl, pay_element_types_f_tl element_tl
675: where classif_tl.classification_id = classif.classification_id
676: and classif_tl.language = userenv('LANG')
677: and element.Element_type_id = element_tl.Element_type_id
678: and element.Element_type_id = p_element_type_id