[Home] [Help]
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'
527: and ENTRY.element_type_id = ETYPE.element_type_id
533: -- Do not select entries which have already had reversal action
534: -- taken against them because they are effectively cancelled out.
535: --
536: select 1
537: from pay_element_entries_f ENTRY2
538: where entry.element_entry_id=entry2.target_entry_id
539: and entry.assignment_id = entry2.assignment_id)
540: --
541: and not exists (
1449: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1450: ssp_smp_pkg.c_amount_name)) AMOUNT,
1451: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1452: ssp_smp_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1453: from pay_element_entries_f ENTRY,
1454: per_all_assignments_f asg
1455: where creator_type = c_SMP_creator_type
1456: and creator_id = p_maternity_id
1457: and asg.person_id = woman.person_id
1463: -- Do not select entries which have already had reversal action taken
1464: -- against them because they are effectively cancelled out.
1465: --
1466: select 1
1467: from pay_element_entries_f ENTRY2
1468: where entry.element_entry_id= entry2.target_entry_id
1469: and entry.assignment_id = entry2.assignment_id)
1470: --
1471: and not exists (
2122: entry.element_entry_id,
2123: entry.effective_start_date
2124: from per_absence_attendances PAA,
2125: per_all_assignments_f PAAF,
2126: pay_element_entries_f entry
2127: where PAA.maternity_id = p_maternity_id
2128: and PAAF.person_id = PAA.person_id
2129: and entry.creator_type = 'M'
2130: and entry.creator_id = p_maternity_id