DBA Data[Home] [Help]

APPS.SSP_SAP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 340: from per_all_assignments_f PAAF,

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

Line 1173: per_all_assignments_f asg

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

Line 1756: per_all_assignments_f PAAF,

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