APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 152: l_entry_information_category pay_element_entries_f.entry_information_category%type;

148: l_element_link_id NUMBER :=0;
149: l_element_entry_id NUMBER :=0;
150: l_object_version_number NUMBER;
151:
152: l_entry_information_category pay_element_entries_f.entry_information_category%type;
153: l_entry_information1 pay_element_entries_f.entry_information1%type;
154:
155: l_session_date DATE;
156: l_mode VARCHAR2(100);

Line 153: l_entry_information1 pay_element_entries_f.entry_information1%type;

149: l_element_entry_id NUMBER :=0;
150: l_object_version_number NUMBER;
151:
152: l_entry_information_category pay_element_entries_f.entry_information_category%type;
153: l_entry_information1 pay_element_entries_f.entry_information1%type;
154:
155: l_session_date DATE;
156: l_mode VARCHAR2(100);
157:

Line 177: FROM pay_element_entries_f pee,

173:
174: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
175: SELECT pee.element_entry_id,
176: object_version_number
177: FROM pay_element_entries_f pee,
178: pay_element_entry_values_f pev
179: WHERE pee.assignment_id = p_assignment_id
180: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
181: AND pee.element_link_id = p_element_link

Line 191: FROM pay_element_entries_f pee

187: /* Bug# 4244787 - Cursor added to check whether future element entry exists for Tax Information when the mode
188: is UPDATE_CHANGE_INSERT*/
189: CURSOR csr_fut_ele_entry(c_element_entry_id NUMBER, c_effective_date DATE) is
190: SELECT pee.effective_start_date, pee.effective_end_date
191: FROM pay_element_entries_f pee
192: WHERE pee.element_entry_id = c_element_entry_id
193: AND pee.effective_start_date > c_effective_date
194: ORDER BY pee.effective_start_date;
195:

Line 253: FROM pay_element_entries_f pee ,

249: decode(decode(eev6.SCREEN_ENTRY_VALUE,'Y','Y','N','N','YY','Y','NY','N','NYA','N','NYB','N','NYC','N','YYA','Y','YYB','Y','YYC','Y','N'),'Y','Y',decode(eev3.SCREEN_ENTRY_VALUE,'Y','Y','N')) ,
250: eev7.SCREEN_ENTRY_VALUE ,
251: eev8.screen_entry_value ,
252: pee.entry_information1
253: FROM pay_element_entries_f pee ,
254: pay_element_entry_values_f eev0 ,
255: pay_element_entry_values_f eev1 ,
256: pay_element_entry_values_f eev2 ,
257: pay_element_entry_values_f eev3 ,

Line 845: FROM pay_element_entries_f pee,

841:
842: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
843: SELECT pee.element_entry_id
844: ,object_version_number
845: FROM pay_element_entries_f pee,
846: pay_element_entry_values_f pev
847: WHERE pee.assignment_id = p_assignment_id
848: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
849: AND pee.element_link_id = p_element_link

Line 876: pay_element_entries_f pee

872: pee.effective_start_date,
873: pee.effective_end_date
874: FROM pay_element_types_f pet,
875: pay_element_links_f pel,
876: pay_element_entries_f pee
877: WHERE pet.element_name = 'Tax Information'
878: AND pel.element_type_id = pet.element_type_id
879: AND pee.element_link_id = pel.element_link_id
880: AND pee.assignment_id = p_assignment_id

Line 1678: from pay_element_entries_f

1674: and business_group_id = p_business_group_id;
1675: --
1676: cursor csr_element_entry(p_element_link_id number) is
1677: select element_entry_id
1678: from pay_element_entries_f
1679: where assignment_id = p_assignment_id
1680: and element_link_id = p_element_link_id;
1681: --
1682: -- Cursor to check the element links.

Line 1703: l_element_entry_id pay_element_entries_f.element_entry_id%type;

1699: l_procedure varchar2(100) := g_package||'update_adi_tax_crp';
1700: --
1701: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1702: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1703: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1704: l_element_type_id pay_element_types_f.element_type_id%type;
1705: l_element_link_id pay_element_links_f.element_link_id%type;
1706: l_object_version_number per_all_assignments_f.object_version_number%type;
1707: l_create_warning boolean;