[Home] [Help]
338: entry.element_entry_id,
339: entry.effective_start_date
340: from per_all_assignments_f PAAF,
341: pay_element_types_f ETYPE,
342: pay_element_entries_f ENTRY
343: where PAAF.person_id = person.person_id
344: and ETYPE.element_name = c_SAP_element_name
345: and ETYPE.legislation_code = 'GB'
346: and ENTRY.element_type_id = ETYPE.element_type_id
352: -- Do not select entries which have already had reversal action
353: -- taken against them because they are effectively cancelled out.
354: --
355: select 1
356: from pay_element_entries_f ENTRY2
357: where entry.element_entry_id=entry2.target_entry_id
358: and entry.assignment_id = entry2.assignment_id)
359: --
360: and not exists (
1168: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1169: ssp_sap_pkg.c_amount_name)) AMOUNT,
1170: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1171: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1172: from pay_element_entries_f ENTRY,
1173: per_all_assignments_f asg
1174: where creator_type = c_SAP_creator_type
1175: and creator_id = p_maternity_id
1176: and asg.person_id = person.person_id
1182: -- Do not select entries which have already had reversal action taken
1183: -- against them because they are effectively cancelled out.
1184: --
1185: select 1
1186: from pay_element_entries_f ENTRY2
1187: where entry.element_entry_id= entry2.target_entry_id
1188: and entry.assignment_id = entry2.assignment_id)
1189: --
1190: and not exists (
1753: entry.element_entry_id,
1754: entry.effective_start_date
1755: from per_absence_attendances PAA,
1756: per_all_assignments_f PAAF,
1757: pay_element_entries_f entry
1758: where PAA.maternity_id = p_maternity_id
1759: and PAAF.person_id = PAA.person_id
1760: and entry.creator_type = 'M'
1761: and entry.creator_id = p_maternity_id