DBA Data[Home] [Help]

APPS.SSP_APAB_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 401: from per_all_assignments_f PAAF,

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

Line 1062: per_all_assignments_f asg

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

Line 1702: per_all_assignments_f PAAF,

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