[Home] [Help]
340: entry.element_entry_id,
341: entry.effective_start_date
342: from per_all_assignments_f PAAF,
343: pay_element_types_f ETYPE,
344: pay_element_entries_f ENTRY
345: where PAAF.person_id = person.person_id
346: and ETYPE.element_name = c_SAP_element_name
347: and ETYPE.legislation_code = 'GB'
348: and ENTRY.element_type_id = ETYPE.element_type_id
354: -- Do not select entries which have already had reversal action
355: -- taken against them because they are effectively cancelled out.
356: --
357: select 1
358: from pay_element_entries_f ENTRY2
359: where entry.element_entry_id=entry2.target_entry_id
360: and entry.assignment_id = entry2.assignment_id)
361: --
362: and not exists (
1175: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1176: ssp_sap_pkg.c_amount_name)) AMOUNT,
1177: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1178: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1179: from pay_element_entries_f ENTRY,
1180: per_all_assignments_f asg
1181: where creator_type = c_SAP_creator_type
1182: and creator_id = p_maternity_id
1183: and asg.person_id = person.person_id
1189: -- Do not select entries which have already had reversal action taken
1190: -- against them because they are effectively cancelled out.
1191: --
1192: select 1
1193: from pay_element_entries_f ENTRY2
1194: where entry.element_entry_id= entry2.target_entry_id
1195: and entry.assignment_id = entry2.assignment_id)
1196: --
1197: and not exists (
1760: entry.element_entry_id,
1761: entry.effective_start_date
1762: from per_absence_attendances PAA,
1763: per_all_assignments_f PAAF,
1764: pay_element_entries_f entry
1765: where PAA.maternity_id = p_maternity_id
1766: and PAAF.person_id = PAA.person_id
1767: and entry.creator_type = 'M'
1768: and entry.creator_id = p_maternity_id