APPS.SSP_SMP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 162: to per_all_people_f and per_all_assignments_f

158: 16-JUN-2006 ajeyam 115.29 5210118 In check_continuity_rule procedure,
159: period_of_service cursor changed to fetch the
160: latest start date for rehired persons.
161: 23-AUG-2006 kthampan 115.30 5482199 Change from per_people_f and per_assignments_f
162: to per_all_people_f and per_all_assignments_f
163: 19-SEP-2006 kthampan 115.31 5547703 Amend smp_control to call generate_payments
164: with insert-mode if absence is > 0 and
165: also change csr_check_if_existing_entries
166: not to reference from per_absence_attendances

Line 528: from per_all_assignments_f PAAF,

524: --
525: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
526: entry.element_entry_id,
527: entry.effective_start_date
528: from per_all_assignments_f PAAF,
529: pay_element_types_f ETYPE,
530: pay_element_entries_f ENTRY
531: where PAAF.person_id = woman.person_id
532: and ETYPE.element_name = c_SMP_element_name

Line 1533: per_all_assignments_f asg

1529: to_number(replace(ssp_smp_support_pkg.value (entry.element_entry_id,
1530: ssp_smp_pkg.c_recoverable_amount_name), l_group_separator, '')) RECOVERABLE_AMOUNT
1531: -- End Bug Fix for 7680593
1532: from pay_element_entries_f ENTRY,
1533: per_all_assignments_f asg
1534: where creator_type = c_SMP_creator_type
1535: and creator_id = p_maternity_id
1536: and asg.person_id = woman.person_id
1537: and asg.assignment_id = entry.assignment_id

Line 2204: per_all_assignments_f PAAF,

2200: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
2201: entry.element_entry_id,
2202: entry.effective_start_date
2203: from per_absence_attendances PAA,
2204: per_all_assignments_f PAAF,
2205: pay_element_entries_f entry
2206: where PAA.maternity_id = p_maternity_id
2207: and PAAF.person_id = PAA.person_id
2208: and entry.creator_type = 'M'