APPS.SSP_SAP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 343: pay_element_types_f ETYPE,

339: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
340: entry.element_entry_id,
341: entry.effective_start_date
342: from per_all_assignments_f PAAF,
343: pay_element_types_f ETYPE,
344: pay_element_entries_f ENTRY
345: where PAAF.person_id = person.person_id
346: and ETYPE.element_name = c_SAP_element_name
347: and ETYPE.legislation_code = 'GB'

Line 368: pay_element_types_f TYPE

364: -- Do not select reversal entries
365: --
366: select 1
367: from pay_element_links_f LINK,
368: pay_element_types_f TYPE
369: where link.element_link_id = entry.element_link_id
370: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
371: and link.element_type_id = type.element_type_id
372: and link.effective_start_date between type.effective_start_date and type.effective_end_date

Line 1203: pay_element_types_f TYPE

1199: -- Do not select reversal entries
1200: --
1201: select 1
1202: from pay_element_links_f LINK,
1203: pay_element_types_f TYPE
1204: where link.element_link_id = entry.element_link_id
1205: and entry.effective_start_date between link.effective_start_date
1206: and link.effective_end_date
1207: and link.element_type_id = type.element_type_id

Line 1843: from pay_element_types_f

1839: where maternity_id = p_maternity_id;
1840:
1841: cursor get_maximum_mpp is
1842: select to_number(element_information3)
1843: from pay_element_types_f
1844: where element_name = c_SAP_element_name
1845: and l_due_date between effective_start_date and effective_end_date;
1846: begin
1847: open get_person_details;