DBA Data[Home] [Help]

APPS.PAY_FR_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 49: l_assignment_id pay_element_entries_f.assignment_id%type;

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
53: select et.element_name, entry.assignment_id

Line 100: pay_element_entries_f ee,

96: cursor csr_process_type_entry_value is
97: select SCREEN_ENTRY_VALUE from
98: pay_assignment_actions aa,
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

Line 380: from pay_element_entries_f pee1,

376: max(decode(piv.name,'Contribution_Usage_ID',eev1.screen_entry_value)) cui1,
377: max(decode(piv.name,'Contribution_Usage_ID',eev2.screen_entry_value)) cui2,
378: max(decode(piv.name,'Rate Type',eev1.screen_entry_value)) rt1,
379: max(decode(piv.name,'Rate Type',eev2.screen_entry_value)) rt2
380: from pay_element_entries_f pee1,
381: pay_element_entries_f pee2,
382: pay_entry_process_details epd1,
383: pay_entry_process_details epd2,
384: pay_element_entry_values_f eev1,

Line 381: pay_element_entries_f pee2,

377: max(decode(piv.name,'Contribution_Usage_ID',eev2.screen_entry_value)) cui2,
378: max(decode(piv.name,'Rate Type',eev1.screen_entry_value)) rt1,
379: max(decode(piv.name,'Rate Type',eev2.screen_entry_value)) rt2
380: from pay_element_entries_f pee1,
381: pay_element_entries_f pee2,
382: pay_entry_process_details epd1,
383: pay_entry_process_details epd2,
384: pay_element_entry_values_f eev1,
385: pay_element_entry_values_f eev2,