DBA Data[Home] [Help]

APPS.OTFR2483 dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 403: from pay_element_classifications pri_class,

399: ,max(decode(pri_class.classification_name
400: ,'Information',sub_class.classification_id)) dif_inf_sub_cls_id
401: ,max(decode(pri_class.classification_name
402: ,'Absence',sub_class.classification_id)) dif_abs_sub_cls_id
403: from pay_element_classifications pri_class,
404: pay_element_classifications sub_class
405: where pri_class.classification_name in ('Information','Absence')
406: and pri_class.business_group_id is null
407: and pri_class.legislation_code = 'FR'

Line 404: pay_element_classifications sub_class

400: ,'Information',sub_class.classification_id)) dif_inf_sub_cls_id
401: ,max(decode(pri_class.classification_name
402: ,'Absence',sub_class.classification_id)) dif_abs_sub_cls_id
403: from pay_element_classifications pri_class,
404: pay_element_classifications sub_class
405: where pri_class.classification_name in ('Information','Absence')
406: and pri_class.business_group_id is null
407: and pri_class.legislation_code = 'FR'
408: and sub_class.parent_classification_id = pri_class.classification_id