[Home] [Help]
373: entry.element_entry_id,
374: entry.effective_start_date
375: from per_all_assignments_f PAAF,
376: pay_element_types_f ETYPE,
377: pay_element_entries_f ENTRY
378: where PAAF.person_id = person.person_id
379: and ETYPE.element_name = c_PAB_element_name
380: and ETYPE.legislation_code = 'GB'
381: and ENTRY.element_type_id = ETYPE.element_type_id
387: -- Do not select entries which have already had reversal action
388: -- taken against them because they are effectively cancelled out.
389: --
390: select 1
391: from pay_element_entries_f ENTRY2
392: where entry.element_entry_id= entry2.target_entry_id
393: and entry.assignment_id = entry2.assignment_id)
394: --
395: and not exists (
1099: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1100: ssp_sap_pkg.c_amount_name)) AMOUNT,
1101: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1102: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1103: from pay_element_entries_f ENTRY,
1104: per_all_assignments_f asg
1105: where creator_type = c_PAB_creator_type
1106: and creator_id = p_maternity_id
1107: and asg.person_id = person.person_id
1113: -- Do not select entries which have already had reversal action taken
1114: -- against them because they are effectively cancelled out.
1115: --
1116: select 1
1117: from pay_element_entries_f ENTRY2
1118: where entry.element_entry_id= entry2.target_entry_id
1119: and entry.assignment_id = entry2.assignment_id)
1120: --
1121: and not exists (
1693: entry.element_entry_id,
1694: entry.effective_start_date
1695: from per_absence_attendances PAA,
1696: per_all_assignments_f PAAF,
1697: pay_element_entries_f entry
1698: where PAA.maternity_id = p_maternity_id
1699: and PAAF.person_id = PAA.person_id
1700: and entry.creator_type = 'M'
1701: and entry.creator_id = p_maternity_id