[Home] [Help]
370: entry.element_entry_id,
371: entry.effective_start_date
372: from per_all_assignments_f PAAF,
373: pay_element_types_f ETYPE,
374: pay_element_entries_f ENTRY
375: where PAAF.person_id = person.person_id
376: and ETYPE.element_name = c_PAB_element_name
377: and ETYPE.legislation_code = 'GB'
378: and ENTRY.element_type_id = ETYPE.element_type_id
384: -- Do not select entries which have already had reversal action
385: -- taken against them because they are effectively cancelled out.
386: --
387: select 1
388: from pay_element_entries_f ENTRY2
389: where entry.element_entry_id= entry2.target_entry_id
390: and entry.assignment_id = entry2.assignment_id)
391: --
392: and not exists (
1090: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1091: ssp_sap_pkg.c_amount_name)) AMOUNT,
1092: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1093: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1094: from pay_element_entries_f ENTRY,
1095: per_all_assignments_f asg
1096: where creator_type = c_PAB_creator_type
1097: and creator_id = p_maternity_id
1098: and asg.person_id = person.person_id
1104: -- Do not select entries which have already had reversal action taken
1105: -- against them because they are effectively cancelled out.
1106: --
1107: select 1
1108: from pay_element_entries_f ENTRY2
1109: where entry.element_entry_id= entry2.target_entry_id
1110: and entry.assignment_id = entry2.assignment_id)
1111: --
1112: and not exists (
1684: entry.element_entry_id,
1685: entry.effective_start_date
1686: from per_absence_attendances PAA,
1687: per_all_assignments_f PAAF,
1688: pay_element_entries_f entry
1689: where PAA.maternity_id = p_maternity_id
1690: and PAAF.person_id = PAA.person_id
1691: and entry.creator_type = 'M'
1692: and entry.creator_id = p_maternity_id