APPS.SSP_APAB_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 88: from pay_element_types_f ele1

84: ele1.effective_end_date,
85: to_number (ele1.element_information4) * 7 MAXIMUM_WEEKS,
86: to_number (ele1.element_information2) * 7 QUALIFYING_WEEK,
87: to_number (ele1.element_information3) * 7 CONTINUOUS_EMPLOYMENT_PERIOD
88: from pay_element_types_f ele1
89: where ele1.element_name = p_element_name
90: and p_effective_date between ele1.effective_start_date
91: and ele1.effective_end_date;
92: --------------------------------------------------------------------------------

Line 402: pay_element_types_f ETYPE,

398: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
399: entry.element_entry_id,
400: entry.effective_start_date
401: from per_all_assignments_f PAAF,
402: pay_element_types_f ETYPE,
403: pay_element_entries_f ENTRY
404: where PAAF.person_id = person.person_id
405: and ETYPE.element_name = c_APAB_element_name
406: and ETYPE.legislation_code = 'GB'

Line 427: pay_element_types_f TYPE

423: -- Do not select reversal entries
424: --
425: select 1
426: from pay_element_links_f LINK,
427: pay_element_types_f TYPE
428: where link.element_link_id = entry.element_link_id
429: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
430: and link.element_type_id = type.element_type_id
431: and link.effective_start_date between type.effective_start_date and type.effective_end_date

Line 1085: pay_element_types_f TYPE

1081: -- Do not select reversal entries
1082: --
1083: select 1
1084: from pay_element_links_f LINK,
1085: pay_element_types_f TYPE
1086: where link.element_link_id = entry.element_link_id
1087: and entry.effective_start_date between link.effective_start_date
1088: and link.effective_end_date
1089: and link.element_type_id = type.element_type_id