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_SAP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 342: from per_all_assignments_f PAAF,

338: --
339: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
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

Line 1180: per_all_assignments_f asg

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
1184: and asg.assignment_id = entry.assignment_id

Line 1763: per_all_assignments_f PAAF,

1759: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
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'