APPS.SSP_PAD_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 335: pay_element_entries_f ENTRY

331: entry.element_entry_id,
332: entry.effective_start_date
333: from per_all_assignments_f PAAF,
334: pay_element_types_f ETYPE,
335: pay_element_entries_f ENTRY
336: where PAAF.person_id = person.person_id
337: and ETYPE.element_name = c_PAD_element_name
338: and ETYPE.legislation_code = 'GB'
339: and ENTRY.element_type_id = ETYPE.element_type_id

Line 349: from pay_element_entries_f ENTRY2

345: -- Do not select entries which have already had reversal action
346: -- taken against them because they are effectively cancelled out.
347: --
348: select 1
349: from pay_element_entries_f ENTRY2
350: where entry.element_entry_id = entry2.target_entry_id
351: and entry.assignment_id = entry2.assignment_id)
352: --
353: and not exists (

Line 1012: from pay_element_entries_f ENTRY,

1008: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1012: from pay_element_entries_f ENTRY,
1013: per_all_assignments_f asg
1014: where creator_type = c_PAD_creator_type
1015: and creator_id = p_maternity_id
1016: and asg.person_id = person.person_id

Line 1026: from pay_element_entries_f ENTRY2

1022: -- Do not select entries which have already had reversal action taken
1023: -- against them because they are effectively cancelled out.
1024: --
1025: select 1
1026: from pay_element_entries_f ENTRY2
1027: where entry.element_entry_id= entry2.target_entry_id
1028: and entry.assignment_id = entry2.assignment_id)
1029: --
1030: and not exists (

Line 1599: pay_element_entries_f entry

1595: select entry.element_entry_id,
1596: entry.effective_start_date
1597: from per_absence_attendances PAA,
1598: per_all_assignments_f PAAF,
1599: pay_element_entries_f entry
1600: where PAA.maternity_id = p_maternity_id
1601: and PAAF.person_id = PAA.person_id
1602: and entry.creator_type = 'M'
1603: and entry.creator_id = p_maternity_id