APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ELEMENT_LINKS_F

Line 4564: pay_element_links_f link

4560: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4561: FROM pay_element_entries_f e,
4562: pay_element_entry_values_f v,
4563: pay_input_values_f iv,
4564: pay_element_links_f link
4565: WHERE e.assignment_id = p_asg_id
4566: AND link.element_type_id = g_paye_details_id
4567: AND e.element_link_id = link.element_link_id
4568: AND e.element_entry_id = v.element_entry_id

Line 4575: pay_element_links_f link1

4571: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4572: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4573: AND e.effective_end_date = (select max(e1.effective_end_date)
4574: from pay_element_entries_f e1,
4575: pay_element_links_f link1
4576: where link1.element_type_id = g_paye_details_id
4577: and e1.assignment_id = p_asg_id
4578: and e1.element_link_id = link1.element_link_id);
4579:

Line 4837: pay_element_links_f link

4833: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4834: FROM pay_element_entries_f e,
4835: pay_element_entry_values_f v,
4836: pay_input_values_f iv,
4837: pay_element_links_f link
4838: WHERE e.assignment_id = p_asg_id
4839: AND link.element_type_id = g_paye_details_id
4840: AND e.element_link_id = link.element_link_id
4841: AND e.element_entry_id = v.element_entry_id

Line 4848: pay_element_links_f link1

4844: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4845: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4846: AND e.effective_end_date = (select max(e1.effective_end_date)
4847: from pay_element_entries_f e1,
4848: pay_element_links_f link1
4849: where link1.element_type_id = g_paye_details_id
4850: and e1.assignment_id = p_asg_id
4851: and e1.element_link_id = link1.element_link_id);
4852:

Line 5105: pay_element_links_f link

5101: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
5102: FROM pay_element_entries_f e,
5103: pay_element_entry_values_f v,
5104: pay_input_values_f iv,
5105: pay_element_links_f link
5106: WHERE e.assignment_id = p_asg_id
5107: AND link.element_type_id = g_paye_details_id
5108: AND e.element_link_id = link.element_link_id
5109: AND e.element_entry_id = v.element_entry_id

Line 5116: pay_element_links_f link1

5112: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
5113: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
5114: AND e.effective_end_date = (select max(e1.effective_end_date)
5115: from pay_element_entries_f e1,
5116: pay_element_links_f link1
5117: where link1.element_type_id = g_paye_details_id
5118: and e1.assignment_id = p_asg_id
5119: and e1.element_link_id = link1.element_link_id);
5120:

Line 5787: pay_element_links_f link

5783: max(decode(iv.name,'Tax Basis',decode(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- added by kvinayku 14774165
5784: FROM pay_element_entries_f e,
5785: pay_element_entry_values_f v,
5786: pay_input_values_f iv,
5787: pay_element_links_f link
5788: WHERE e.assignment_id = p_asg_id
5789: AND link.element_type_id = g_paye_details_id
5790: AND e.element_link_id = link.element_link_id
5791: AND e.element_entry_id = v.element_entry_id

Line 5798: pay_element_links_f link1

5794: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
5795: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
5796: AND e.effective_end_date = (select max(e1.effective_end_date)
5797: from pay_element_entries_f e1,
5798: pay_element_links_f link1
5799: where link1.element_type_id = g_paye_details_id
5800: and e1.assignment_id = p_asg_id
5801: and e1.element_link_id = link1.element_link_id);
5802: