[Home] [Help]
354: entry.element_entry_id,
355: entry.effective_start_date
356: from per_all_assignments_f PAAF,
357: pay_element_types_f ETYPE,
358: pay_element_entries_f ENTRY
359: where PAAF.person_id = person.person_id
360: and ETYPE.element_name = c_APAD_element_name
361: and ETYPE.legislation_code = 'GB'
362: and ENTRY.element_type_id = ETYPE.element_type_id
368: -- Do not select entries which have already had reversal action
369: -- taken against them because they are effectively cancelled out.
370: --
371: select 1
372: from pay_element_entries_f ENTRY2
373: where entry.element_entry_id = entry2.target_entry_id
374: and entry.assignment_id = entry2.assignment_id)
375: --
376: and not exists (
980: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
981: ssp_APAD_pkg.c_amount_name)) AMOUNT,
982: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
983: ssp_APAD_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
984: from pay_element_entries_f ENTRY,
985: per_all_assignments_f asg
986: where creator_type = c_APAD_creator_type
987: and creator_id = p_maternity_id
988: and asg.person_id = person.person_id
994: -- Do not select entries which have already had reversal action taken
995: -- against them because they are effectively cancelled out.
996: --
997: select 1
998: from pay_element_entries_f ENTRY2
999: where entry.element_entry_id= entry2.target_entry_id
1000: and entry.assignment_id = entry2.assignment_id)
1001: --
1002: and not exists (
1615: select entry.element_entry_id,
1616: entry.effective_start_date
1617: from per_absence_attendances PAA,
1618: per_all_assignments_f PAAF,
1619: pay_element_entries_f entry
1620: where PAA.maternity_id = p_maternity_id
1621: and PAAF.person_id = PAA.person_id
1622: and entry.creator_type = 'M'
1623: and entry.creator_id = p_maternity_id