DBA Data[Home] [Help]

APPS.PAY_FR_RUN_TYPES dependencies on PAY_ELEMENT_TYPE_USAGES_F

Line 87: From pay_element_type_usages_f etu

83: ,etu.effective_start_date effective_date
84: ,etu.object_version_number
85: ,etu.business_group_id
86: ,etu.legislation_code
87: From pay_element_type_usages_f etu
88: ,pay_run_types_f rt
89: Where rt.legislation_code = 'FR'
90: And rt.shortname = c_run_type
91: And etu.run_type_id = rt.run_type_id

Line 427: From pay_element_type_usages_f etu

423: ,etu.effective_start_date effective_date
424: ,etu.object_version_number
425: ,etu.business_group_id
426: ,etu.legislation_code
427: From pay_element_type_usages_f etu
428: ,pay_run_types_f rt
429: Where rt.legislation_code = 'FR'
430: And rt.shortname In ('STANDARD', 'NET', 'SICKNESS')
431: And etu.run_type_id = rt.run_type_id;