APPS.SSP_PAD_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 40: to per_all_people_f and per_all_assignments_f

36: one in the cursor csr_existing_entries
37: and twice when calling insert_element_entry
38: 09 Feb 06 kthampan 4891953 Fixed performance bug.
39: 23 Aug 06 Kthampan 5482199 Change from per_people_f and per_assignments_f
40: to per_all_people_f and per_all_assignments_f
41: 19 Sep 06 Kthampan 5547703 Amend pad_control to call generate_payments
42: with insert-mode if absence is > 0 and
43: also change csr_check_if_existing_entries
44: not to reference from per_absence_attendances

Line 333: from per_all_assignments_f PAAF,

329: cursor csr_check_if_existing_entries is
330: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
331: entry.element_entry_id,
332: entry.effective_start_date
333: from per_all_assignments_f PAAF,
334: pay_element_types_f ETYPE,
335: pay_element_entries_f ENTRY
336: where PAAF.person_id = person.person_id
337: and ETYPE.element_name = c_PAD_element_name

Line 1013: per_all_assignments_f asg

1009: ssp_pad_pkg.c_amount_name)) AMOUNT,
1010: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1011: ssp_pad_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1012: from pay_element_entries_f ENTRY,
1013: per_all_assignments_f asg
1014: where creator_type = c_PAD_creator_type
1015: and creator_id = p_maternity_id
1016: and asg.person_id = person.person_id
1017: and asg.assignment_id = entry.assignment_id

Line 1598: per_all_assignments_f PAAF,

1594: cursor csr_entries is
1595: select entry.element_entry_id,
1596: entry.effective_start_date
1597: from per_absence_attendances PAA,
1598: per_all_assignments_f PAAF,
1599: pay_element_entries_f entry
1600: where PAA.maternity_id = p_maternity_id
1601: and PAAF.person_id = PAA.person_id
1602: and entry.creator_type = 'M'