DBA Data[Home] [Help]

APPS.PAY_FR_RULES dependencies on PAY_ELEMENT_LINKS

Line 55: pay_element_links el,

51:
52: cursor csr_get_element_info is
53: select et.element_name, entry.assignment_id
54: from pay_element_entries entry,
55: pay_element_links el,
56: pay_element_types_f_tl et
57: where entry.element_entry_id = p_ee_id
58: and et.element_type_id = el.element_type_id
59: and el.element_link_id = entry.element_link_id

Line 104: pay_element_links_f el

100: pay_element_entries_f ee,
101: pay_element_entry_values_f eev,
102: pay_input_values_f iv,
103: pay_element_types_f et,
104: pay_element_links_f el
105: where aa.assignment_action_id = p_asg_act_id
106: and pa.payroll_action_id = aa.payroll_action_id
107: and aa.assignment_id = ee.assignment_id
108: and iv.input_value_id = eev.input_value_id