[Home] [Help]
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'
534: and ENTRY.element_type_id = ETYPE.element_type_id
540: -- Do not select entries which have already had reversal action
541: -- taken against them because they are effectively cancelled out.
542: --
543: select 1
544: from pay_element_entries_f ENTRY2
545: where entry.element_entry_id=entry2.target_entry_id
546: and entry.assignment_id = entry2.assignment_id)
547: --
548: and not exists (
1528: ssp_smp_pkg.c_amount_name), l_group_separator, '')) AMOUNT,
1529: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1530: ssp_smp_pkg.c_recoverable_amount_name), l_group_separator, '')) RECOVERABLE_AMOUNT
1531: -- End Bug Fix for 7680593
1532: from pay_element_entries_f ENTRY,
1533: per_all_assignments_f asg
1534: where creator_type = c_SMP_creator_type
1535: and creator_id = p_maternity_id
1536: and asg.person_id = woman.person_id
1542: -- Do not select entries which have already had reversal action taken
1543: -- against them because they are effectively cancelled out.
1544: --
1545: select 1
1546: from pay_element_entries_f ENTRY2
1547: where entry.element_entry_id= entry2.target_entry_id
1548: and entry.assignment_id = entry2.assignment_id)
1549: --
1550: and not exists (
2201: entry.element_entry_id,
2202: entry.effective_start_date
2203: from per_absence_attendances PAA,
2204: per_all_assignments_f PAAF,
2205: pay_element_entries_f entry
2206: where PAA.maternity_id = p_maternity_id
2207: and PAAF.person_id = PAA.person_id
2208: and entry.creator_type = 'M'
2209: and entry.creator_id = p_maternity_id