[Home] [Help]
399: entry.element_entry_id,
400: entry.effective_start_date
401: from per_all_assignments_f PAAF,
402: pay_element_types_f ETYPE,
403: pay_element_entries_f ENTRY
404: where PAAF.person_id = person.person_id
405: and ETYPE.element_name = c_APAB_element_name
406: and ETYPE.legislation_code = 'GB'
407: and ENTRY.element_type_id = ETYPE.element_type_id
413: -- Do not select entries which have already had reversal action
414: -- taken against them because they are effectively cancelled out.
415: --
416: select 1
417: from pay_element_entries_f ENTRY2
418: where entry.element_entry_id= entry2.target_entry_id
419: and entry.assignment_id = entry2.assignment_id)
420: --
421: and not exists (
1057: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1058: ssp_apab_pkg.c_amount_name)) AMOUNT,
1059: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1060: ssp_apab_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1061: from pay_element_entries_f ENTRY,
1062: per_all_assignments_f asg
1063: where creator_type = c_APAB_creator_type
1064: and creator_id = p_maternity_id
1065: and asg.person_id = person.person_id
1071: -- Do not select entries which have already had reversal action taken
1072: -- against them because they are effectively cancelled out.
1073: --
1074: select 1
1075: from pay_element_entries_f ENTRY2
1076: where entry.element_entry_id= entry2.target_entry_id
1077: and entry.assignment_id = entry2.assignment_id)
1078: --
1079: and not exists (
1699: entry.element_entry_id,
1700: entry.effective_start_date
1701: from per_absence_attendances PAA,
1702: per_all_assignments_f PAAF,
1703: pay_element_entries_f entry
1704: where PAA.maternity_id = p_maternity_id
1705: and PAAF.person_id = PAA.person_id
1706: and entry.creator_type = 'M'
1707: and entry.creator_id = p_maternity_id