APPS.SSP_PAB_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 41: to per_all_people_f and per_all_assignments_f

37: 18 Oct 05 4670360 KThampan Amended parameter's order of function
38: LATEST_PPP_START_DATE
39: 09 Feb 06 4891953 Kthampan Fixed performance bug.
40: 23 Aug 06 5482199 KThampan Change from per_people_f and per_assignments_f
41: to per_all_people_f and per_all_assignments_f
42: 19 Spe 06 5547703 KThampan Amend pab_control to call generate_payments
43: with insert-mode if absence is > 0 and
44: also change csr_check_if_existing_entries
45: not to reference from per_absence_attendances

Line 375: from per_all_assignments_f PAAF,

371: --
372: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
373: entry.element_entry_id,
374: entry.effective_start_date
375: from per_all_assignments_f PAAF,
376: pay_element_types_f ETYPE,
377: pay_element_entries_f ENTRY
378: where PAAF.person_id = person.person_id
379: and ETYPE.element_name = c_PAB_element_name

Line 1104: per_all_assignments_f asg

1100: ssp_sap_pkg.c_amount_name)) AMOUNT,
1101: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,
1102: ssp_sap_pkg.c_recoverable_amount_name)) RECOVERABLE_AMOUNT
1103: from pay_element_entries_f ENTRY,
1104: per_all_assignments_f asg
1105: where creator_type = c_PAB_creator_type
1106: and creator_id = p_maternity_id
1107: and asg.person_id = person.person_id
1108: and asg.assignment_id = entry.assignment_id

Line 1696: per_all_assignments_f PAAF,

1692: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
1693: entry.element_entry_id,
1694: entry.effective_start_date
1695: from per_absence_attendances PAA,
1696: per_all_assignments_f PAAF,
1697: pay_element_entries_f entry
1698: where PAA.maternity_id = p_maternity_id
1699: and PAAF.person_id = PAA.person_id
1700: and entry.creator_type = 'M'