APPS.SSP_SAP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 341: pay_element_types_f ETYPE,

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

Line 366: pay_element_types_f TYPE

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

Line 1196: pay_element_types_f TYPE

1192: -- Do not select reversal entries
1193: --
1194: select 1
1195: from pay_element_links_f LINK,
1196: pay_element_types_f TYPE
1197: where link.element_link_id = entry.element_link_id
1198: and entry.effective_start_date between link.effective_start_date
1199: and link.effective_end_date
1200: and link.element_type_id = type.element_type_id

Line 1836: from pay_element_types_f

1832: where maternity_id = p_maternity_id;
1833:
1834: cursor get_maximum_mpp is
1835: select to_number(element_information3)
1836: from pay_element_types_f
1837: where element_name = c_SAP_element_name
1838: and l_due_date between effective_start_date and effective_end_date;
1839: begin
1840: open get_person_details;