APPS.SSP_APAD_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 234: from pay_element_types_f ele1

230: select ele1.element_type_id,
231: ele1.effective_start_date,
232: ele1.effective_end_date,
233: to_number (ele1.element_information3) * 7 MAXIMUM_WEEKS
234: from pay_element_types_f ele1
235: where ele1.element_name = p_element_name
236: and p_effective_date between ele1.effective_start_date
237: and ele1.effective_end_date;
238: l_partner_app_end_date date;

Line 357: pay_element_types_f ETYPE,

353: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
354: entry.element_entry_id,
355: entry.effective_start_date
356: from per_all_assignments_f PAAF,
357: pay_element_types_f ETYPE,
358: pay_element_entries_f ENTRY
359: where PAAF.person_id = person.person_id
360: and ETYPE.element_name = c_APAD_element_name
361: and ETYPE.legislation_code = 'GB'

Line 382: pay_element_types_f TYPE

378: -- Do not select reversal entries
379: --
380: select 1
381: from pay_element_links_f LINK,
382: pay_element_types_f TYPE
383: where link.element_link_id = entry.element_link_id
384: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
385: and link.element_type_id = type.element_type_id
386: and link.effective_start_date between type.effective_start_date and type.effective_end_date

Line 1008: pay_element_types_f TYPE

1004: -- Do not select reversal entries
1005: --
1006: select 1
1007: from pay_element_links_f LINK,
1008: pay_element_types_f TYPE
1009: where link.element_link_id = entry.element_link_id
1010: and entry.effective_start_date between link.effective_start_date
1011: and link.effective_end_date
1012: and link.element_type_id = type.element_type_id