APPS.SSP_SMP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 522: pay_element_types_f ETYPE,

518: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
519: entry.element_entry_id,
520: entry.effective_start_date
521: from per_all_assignments_f PAAF,
522: pay_element_types_f ETYPE,
523: pay_element_entries_f ENTRY
524: where PAAF.person_id = woman.person_id
525: and ETYPE.element_name = c_SMP_element_name
526: and ETYPE.legislation_code = 'GB'

Line 547: pay_element_types_f TYPE

543: -- Do not select reversal entries
544: --
545: select 1
546: from pay_element_links_f LINK,
547: pay_element_types_f TYPE
548: where link.element_link_id = entry.element_link_id
549: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
550: and link.element_type_id = type.element_type_id
551: and link.effective_start_date between type.effective_start_date and type.effective_end_date

Line 1477: pay_element_types_f TYPE

1473: -- Do not select reversal entries
1474: --
1475: select 1
1476: from pay_element_links_f LINK,
1477: pay_element_types_f TYPE
1478: where link.element_link_id = entry.element_link_id
1479: and entry.effective_start_date between link.effective_start_date
1480: and link.effective_end_date
1481: and link.element_type_id = type.element_type_id

Line 2340: pay_element_types_f ELEMENT

2336: -- where the date of death falls within the MPP and leave is recorded.
2337: --
2338: select maternity.maternity_id
2339: from ssp_maternities MATERNITY,
2340: pay_element_types_f ELEMENT
2341: where maternity.person_id = p_person_id
2342: and element.legislation_code = 'GB'
2343: and element.element_name = c_SMP_element_name
2344: and maternity.due_date between element.effective_start_date

Line 2413: from pay_element_types_f

2409: where maternity_id = p_maternity_id;
2410:
2411: cursor get_maximum_mpp is
2412: select to_number(element_information4)
2413: from pay_element_types_f
2414: where element_name = c_SMP_element_name
2415: and l_due_date between effective_start_date and effective_end_date;
2416: begin
2417: open get_person_details;

Line 2439: from pay_element_types_f

2435: l_max_mpp number;
2436:
2437: cursor get_maximum_mpp is
2438: select to_number(element_information4)
2439: from pay_element_types_f
2440: where element_name = c_SMP_element_name
2441: and p_due_date between effective_start_date and effective_end_date;
2442: begin
2443: open get_maximum_mpp;