480: ,pelf.effective_start_date Link_Start_Date
481: ,pelf.effective_end_date Link_End_Date
482: ,pelf.element_link_id Element_Link_Id
483: from pay_element_types_f petf,
484: pay_element_links_f pelf,
485: per_assignments_f paf
486: where petf.element_type_id = c_element_type_id
487: and petf.element_type_id = pelf.element_type_id
488: and paf.assignment_id = c_assignment_id
1404: ,pelf.effective_start_date Link_Start_Date
1405: ,pelf.effective_end_date Link_End_Date
1406: ,pelf.element_link_id Element_Link_Id
1407: from pay_element_types_f petf,
1408: pay_element_links_f pelf,
1409: per_assignments_f paf
1410: where petf.element_type_id = c_element_type_id
1411: and petf.element_type_id = pelf.element_type_id
1412: and paf.assignment_id = c_assignment_id