324: hr_lookups fcl,
325: hr_lookups fcl2,
326: per_assignments_f asg,
327: hr_organization_units_v org,
328: pay_element_types_f pay,
329: pay_element_types_f_tl payt,
330: hxt_pay_element_types_f_ddf_v payd,
331: pa_projects_all prj,
332: pa_tasks_expend_v task /*Bug 16391367*/
325: hr_lookups fcl2,
326: per_assignments_f asg,
327: hr_organization_units_v org,
328: pay_element_types_f pay,
329: pay_element_types_f_tl payt,
330: hxt_pay_element_types_f_ddf_v payd,
331: pa_projects_all prj,
332: pa_tasks_expend_v task /*Bug 16391367*/
333: WHERE det.parent_id = c_summary_id
326: per_assignments_f asg,
327: hr_organization_units_v org,
328: pay_element_types_f pay,
329: pay_element_types_f_tl payt,
330: hxt_pay_element_types_f_ddf_v payd,
331: pa_projects_all prj,
332: pa_tasks_expend_v task /*Bug 16391367*/
333: WHERE det.parent_id = c_summary_id
334: AND det.pa_status = 'R'
427: hr_lookups fcl, --FORMS60
428: hr_lookups fcl2, --FORMS60
429: per_assignments_f asg,
430: hr_organization_units_v org,
431: pay_element_types_f pay,
432: pay_element_types_f_tl payt, --FORMS60
433: hxt_pay_element_types_f_ddf_v payd,
434: pa_projects_all prj,
435: pa_tasks_expend_v task /*Bug 16391367*/
428: hr_lookups fcl2, --FORMS60
429: per_assignments_f asg,
430: hr_organization_units_v org,
431: pay_element_types_f pay,
432: pay_element_types_f_tl payt, --FORMS60
433: hxt_pay_element_types_f_ddf_v payd,
434: pa_projects_all prj,
435: pa_tasks_expend_v task /*Bug 16391367*/
436: WHERE det.parent_id = c_summary_id
429: per_assignments_f asg,
430: hr_organization_units_v org,
431: pay_element_types_f pay,
432: pay_element_types_f_tl payt, --FORMS60
433: hxt_pay_element_types_f_ddf_v payd,
434: pa_projects_all prj,
435: pa_tasks_expend_v task /*Bug 16391367*/
436: WHERE det.parent_id = c_summary_id
437: AND det.pa_status = 'C'