APPS.SSP_SMP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 529: pay_element_types_f ETYPE,

525: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
526: entry.element_entry_id,
527: entry.effective_start_date
528: from per_all_assignments_f PAAF,
529: pay_element_types_f ETYPE,
530: pay_element_entries_f ENTRY
531: where PAAF.person_id = woman.person_id
532: and ETYPE.element_name = c_SMP_element_name
533: and ETYPE.legislation_code = 'GB'

Line 554: pay_element_types_f TYPE

550: -- Do not select reversal entries
551: --
552: select 1
553: from pay_element_links_f LINK,
554: pay_element_types_f TYPE
555: where link.element_link_id = entry.element_link_id
556: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
557: and link.element_type_id = type.element_type_id
558: and link.effective_start_date between type.effective_start_date and type.effective_end_date

Line 1556: pay_element_types_f TYPE

1552: -- Do not select reversal entries
1553: --
1554: select 1
1555: from pay_element_links_f LINK,
1556: pay_element_types_f TYPE
1557: where link.element_link_id = entry.element_link_id
1558: and entry.effective_start_date between link.effective_start_date
1559: and link.effective_end_date
1560: and link.element_type_id = type.element_type_id

Line 2421: pay_element_types_f ELEMENT

2417: -- where the date of death falls within the MPP and leave is recorded.
2418: --
2419: select maternity.maternity_id
2420: from ssp_maternities MATERNITY,
2421: pay_element_types_f ELEMENT
2422: where maternity.person_id = p_person_id
2423: and element.legislation_code = 'GB'
2424: and element.element_name = c_SMP_element_name
2425: and maternity.due_date between element.effective_start_date

Line 2494: from pay_element_types_f

2490: where maternity_id = p_maternity_id;
2491:
2492: cursor get_maximum_mpp is
2493: select to_number(element_information4)
2494: from pay_element_types_f
2495: where element_name = c_SMP_element_name
2496: and l_due_date between effective_start_date and effective_end_date;
2497: begin
2498: open get_person_details;

Line 2520: from pay_element_types_f

2516: l_max_mpp number;
2517:
2518: cursor get_maximum_mpp is
2519: select to_number(element_information4)
2520: from pay_element_types_f
2521: where element_name = c_SMP_element_name
2522: and p_due_date between effective_start_date and effective_end_date;
2523: begin
2524: open get_maximum_mpp;