eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSP_APAD_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 356: from per_all_assignments_f PAAF,

352: cursor csr_check_if_existing_entries is
353: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
354: entry.element_entry_id,
355: entry.effective_start_date
356: from per_all_assignments_f PAAF,
357: pay_element_types_f ETYPE,
358: pay_element_entries_f ENTRY
359: where PAAF.person_id = person.person_id
360: and ETYPE.element_name = c_APAD_element_name

Line 985: per_all_assignments_f asg

981: ssp_APAD_pkg.c_amount_name)) AMOUNT,
982: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
983: ssp_APAD_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
984: from pay_element_entries_f ENTRY,
985: per_all_assignments_f asg
986: where creator_type = c_APAD_creator_type
987: and creator_id = p_maternity_id
988: and asg.person_id = person.person_id
989: and asg.assignment_id = entry.assignment_id

Line 1618: per_all_assignments_f PAAF,

1614: cursor csr_entries is
1615: select entry.element_entry_id,
1616: entry.effective_start_date
1617: from per_absence_attendances PAA,
1618: per_all_assignments_f PAAF,
1619: pay_element_entries_f entry
1620: where PAA.maternity_id = p_maternity_id
1621: and PAAF.person_id = PAA.person_id
1622: and entry.creator_type = 'M'