DBA Data[Home] [Help]

APPS.SSP_PAB_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 376: pay_element_types_f ETYPE,

372: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
373: entry.element_entry_id,
374: entry.effective_start_date
375: from per_all_assignments_f PAAF,
376: pay_element_types_f ETYPE,
377: pay_element_entries_f ENTRY
378: where PAAF.person_id = person.person_id
379: and ETYPE.element_name = c_PAB_element_name
380: and ETYPE.legislation_code = 'GB'

Line 401: pay_element_types_f TYPE

397: -- Do not select reversal entries
398: --
399: select 1
400: from pay_element_links_f LINK,
401: pay_element_types_f TYPE
402: where link.element_link_id = entry.element_link_id
403: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
404: and link.element_type_id = type.element_type_id
405: and link.effective_start_date between type.effective_start_date and type.effective_end_date

Line 1127: pay_element_types_f TYPE

1123: -- Do not select reversal entries
1124: --
1125: select 1
1126: from pay_element_links_f LINK,
1127: pay_element_types_f TYPE
1128: where link.element_link_id = entry.element_link_id
1129: and entry.effective_start_date between link.effective_start_date
1130: and link.effective_end_date
1131: and link.element_type_id = type.element_type_id