APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 140: l_entry_information_category pay_element_entries_f.entry_information_category%type;

136: l_element_link_id NUMBER :=0;
137: l_element_entry_id NUMBER :=0;
138: l_object_version_number NUMBER;
139:
140: l_entry_information_category pay_element_entries_f.entry_information_category%type;
141: l_entry_information1 pay_element_entries_f.entry_information1%type;
142:
143: l_session_date DATE;
144: l_mode VARCHAR2(100);

Line 141: l_entry_information1 pay_element_entries_f.entry_information1%type;

137: l_element_entry_id NUMBER :=0;
138: l_object_version_number NUMBER;
139:
140: l_entry_information_category pay_element_entries_f.entry_information_category%type;
141: l_entry_information1 pay_element_entries_f.entry_information1%type;
142:
143: l_session_date DATE;
144: l_mode VARCHAR2(100);
145:

Line 165: FROM pay_element_entries_f pee,

161:
162: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
163: SELECT pee.element_entry_id,
164: object_version_number
165: FROM pay_element_entries_f pee,
166: pay_element_entry_values_f pev
167: WHERE pee.assignment_id = p_assignment_id
168: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
169: AND pee.element_link_id = p_element_link

Line 179: FROM pay_element_entries_f pee

175: /* Bug# 4244787 - Cursor added to check whether future element entry exists for Tax Information when the mode
176: is UPDATE_CHANGE_INSERT*/
177: CURSOR csr_fut_ele_entry(c_element_entry_id NUMBER, c_effective_date DATE) is
178: SELECT pee.effective_start_date, pee.effective_end_date
179: FROM pay_element_entries_f pee
180: WHERE pee.element_entry_id = c_element_entry_id
181: AND pee.effective_start_date > c_effective_date
182: ORDER BY pee.effective_start_date;
183:

Line 238: FROM pay_element_entries_f pee ,

234: eev5.SCREEN_ENTRY_VALUE ,
235: decode(decode(eev6.SCREEN_ENTRY_VALUE,'Y','Y','N','N','YY','Y','NY','N','N'),'Y','Y',decode(eev3.SCREEN_ENTRY_VALUE,'Y','Y','N')) ,
236: eev7.SCREEN_ENTRY_VALUE ,
237: pee.entry_information1
238: FROM pay_element_entries_f pee ,
239: pay_element_entry_values_f eev0 ,
240: pay_element_entry_values_f eev1 ,
241: pay_element_entry_values_f eev2 ,
242: pay_element_entry_values_f eev3 ,

Line 806: FROM pay_element_entries_f pee,

802:
803: CURSOR csr_ele_entry (p_element_link NUMBER, p_inp_val NUMBER)IS
804: SELECT pee.element_entry_id
805: ,object_version_number
806: FROM pay_element_entries_f pee,
807: pay_element_entry_values_f pev
808: WHERE pee.assignment_id = p_assignment_id
809: AND l_session_date BETWEEN pee.effective_start_date AND pee.effective_end_date
810: AND pee.element_link_id = p_element_link

Line 837: pay_element_entries_f pee

833: pee.effective_start_date,
834: pee.effective_end_date
835: FROM pay_element_types_f pet,
836: pay_element_links_f pel,
837: pay_element_entries_f pee
838: WHERE pet.element_name = 'Tax Information'
839: AND pel.element_type_id = pet.element_type_id
840: AND pee.element_link_id = pel.element_link_id
841: AND pee.assignment_id = p_assignment_id

Line 1636: from pay_element_entries_f

1632: and business_group_id = p_business_group_id;
1633: --
1634: cursor csr_element_entry(p_element_link_id number) is
1635: select element_entry_id
1636: from pay_element_entries_f
1637: where assignment_id = p_assignment_id
1638: and element_link_id = p_element_link_id;
1639: --
1640: -- Cursor to check the element links.

Line 1661: l_element_entry_id pay_element_entries_f.element_entry_id%type;

1657: l_procedure varchar2(100) := g_package||'update_adi_tax_crp';
1658: --
1659: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1660: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1661: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1662: l_element_type_id pay_element_types_f.element_type_id%type;
1663: l_element_link_id pay_element_links_f.element_link_id%type;
1664: l_object_version_number per_all_assignments_f.object_version_number%type;
1665: l_create_warning boolean;