DBA Data[Home] [Help]

APPS.PAY_FR_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 48: l_element_name pay_element_types_f.element_name%type;

44:
45:
46: procedure raise_null_context_input(p_ee_id number,p_cxt_name varchar2)
47: is
48: l_element_name pay_element_types_f.element_name%type;
49: l_assignment_id pay_element_entries_f.assignment_id%type;
50: l_input_name pay_legislation_contexts.input_value_name%type;
51:
52: cursor csr_get_element_info is

Line 56: pay_element_types_f_tl et

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
60: and et.language = userenv('lang');

Line 103: pay_element_types_f et,

99: pay_payroll_actions pa,
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