DBA Data[Home] [Help]

APPS.HR_TEMPLATE_DATA_GROUPS_API dependencies on HR_FORM_DATA_GROUP_ITEMS

Line 229: ,hr_form_data_group_items fgi

225: IS
226: SELECT fit.form_item_id
227: FROM hr_template_items tit
228: ,hr_form_items fit
229: ,hr_form_data_group_items fgi
230: WHERE tit.template_item_id IS NULL
231: AND tit.form_template_id (+) = p_form_template_id
232: AND tit.form_item_id (+) = fit.form_item_id
233: AND fit.form_item_id = fgi.form_item_id

Line 397: ,hr_form_data_group_items fgi

393: IS
394: SELECT tit.template_item_id
395: ,tit.object_version_number
396: FROM hr_template_items tit
397: ,hr_form_data_group_items fgi
398: ,hr_template_data_groups tdg
399: WHERE tit.form_template_id = tdg.form_template_id
400: AND tit.form_item_id = fgi.form_item_id
401: AND fgi.form_data_group_id = tdg.form_data_group_id

Line 407: ,hr_form_data_group_items fgi

403: MINUS
404: SELECT tit.template_item_id
405: ,tit.object_version_number
406: FROM hr_template_items tit
407: ,hr_form_data_group_items fgi
408: ,hr_template_data_groups tdg2
409: ,hr_template_data_groups tdg1
410: WHERE tit.form_template_id = tdg2.form_template_id
411: AND tit.form_item_id = fgi.form_item_id