eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PERSON_OBJECT dependencies on PER_ASSIGNMENTS_F

Line 2106: from per_assignments_f paf,

2102: l_index pls_integer;
2103: --
2104: cursor c1(p_primary_flag varchar2) is
2105: select sum(pab.value)
2106: from per_assignments_f paf,
2107: per_assignment_budget_values_f pab
2108: where paf.assignment_id = p_assignment_id
2109: and paf.business_group_id = p_business_group_id
2110: and paf.primary_flag = nvl(p_primary_flag,paf.primary_flag)

Line 2124: from per_assignments_f paf,

2120: --
2121: -- Bug#2179708 - to sum for all the assignments, person_id needs to be joined
2122: cursor c2 is
2123: select sum(pab.value)
2124: from per_assignments_f paf,
2125: per_assignment_budget_values_f pab,
2126: per_assignments_f paf2
2127: where paf.assignment_id = p_assignment_id
2128: and paf.business_group_id = p_business_group_id

Line 2126: per_assignments_f paf2

2122: cursor c2 is
2123: select sum(pab.value)
2124: from per_assignments_f paf,
2125: per_assignment_budget_values_f pab,
2126: per_assignments_f paf2
2127: where paf.assignment_id = p_assignment_id
2128: and paf.business_group_id = p_business_group_id
2129: and p_effective_date
2130: between paf.effective_start_date