APPS.PAY_GB_RTI_FPS dependencies on PAY_ELEMENT_LINKS_F

Line 3988: pay_element_links_f link

3984: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
3985: FROM pay_element_entries_f e,
3986: pay_element_entry_values_f v,
3987: pay_input_values_f iv,
3988: pay_element_links_f link
3989: WHERE e.assignment_id = p_asg_id
3990: AND link.element_type_id = g_paye_details_id
3991: AND e.element_link_id = link.element_link_id
3992: AND e.element_entry_id = v.element_entry_id

Line 3999: pay_element_links_f link1

3995: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
3996: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
3997: AND e.effective_end_date = (select max(e1.effective_end_date)
3998: from pay_element_entries_f e1,
3999: pay_element_links_f link1
4000: where link1.element_type_id = g_paye_details_id
4001: and e1.assignment_id = p_asg_id
4002: and e1.element_link_id = link1.element_link_id);
4003:

Line 4250: pay_element_links_f link

4246: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4247: FROM pay_element_entries_f e,
4248: pay_element_entry_values_f v,
4249: pay_input_values_f iv,
4250: pay_element_links_f link
4251: WHERE e.assignment_id = p_asg_id
4252: AND link.element_type_id = g_paye_details_id
4253: AND e.element_link_id = link.element_link_id
4254: AND e.element_entry_id = v.element_entry_id

Line 4261: pay_element_links_f link1

4257: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4258: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4259: AND e.effective_end_date = (select max(e1.effective_end_date)
4260: from pay_element_entries_f e1,
4261: pay_element_links_f link1
4262: where link1.element_type_id = g_paye_details_id
4263: and e1.assignment_id = p_asg_id
4264: and e1.element_link_id = link1.element_link_id);
4265:

Line 4507: pay_element_links_f link

4503: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
4504: FROM pay_element_entries_f e,
4505: pay_element_entry_values_f v,
4506: pay_input_values_f iv,
4507: pay_element_links_f link
4508: WHERE e.assignment_id = p_asg_id
4509: AND link.element_type_id = g_paye_details_id
4510: AND e.element_link_id = link.element_link_id
4511: AND e.element_entry_id = v.element_entry_id

Line 4518: pay_element_links_f link1

4514: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
4515: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
4516: AND e.effective_end_date = (select max(e1.effective_end_date)
4517: from pay_element_entries_f e1,
4518: pay_element_links_f link1
4519: where link1.element_type_id = g_paye_details_id
4520: and e1.assignment_id = p_asg_id
4521: and e1.element_link_id = link1.element_link_id);
4522:

Line 5173: pay_element_links_f link

5169: max(decode(iv.name,'Tax Basis',decode(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- added by kvinayku 14774165
5170: FROM pay_element_entries_f e,
5171: pay_element_entry_values_f v,
5172: pay_input_values_f iv,
5173: pay_element_links_f link
5174: WHERE e.assignment_id = p_asg_id
5175: AND link.element_type_id = g_paye_details_id
5176: AND e.element_link_id = link.element_link_id
5177: AND e.element_entry_id = v.element_entry_id

Line 5184: pay_element_links_f link1

5180: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
5181: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
5182: AND e.effective_end_date = (select max(e1.effective_end_date)
5183: from pay_element_entries_f e1,
5184: pay_element_links_f link1
5185: where link1.element_type_id = g_paye_details_id
5186: and e1.assignment_id = p_asg_id
5187: and e1.element_link_id = link1.element_link_id);
5188: