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 2052: from per_assignments_f paf,

2048: l_index pls_integer;
2049: --
2050: cursor c1(p_primary_flag varchar2) is
2051: select sum(pab.value)
2052: from per_assignments_f paf,
2053: per_assignment_budget_values_f pab
2054: where paf.assignment_id = p_assignment_id
2055: and paf.business_group_id = p_business_group_id
2056: and paf.primary_flag = nvl(p_primary_flag,paf.primary_flag)

Line 2070: from per_assignments_f paf,

2066: --
2067: -- Bug#2179708 - to sum for all the assignments, person_id needs to be joined
2068: cursor c2 is
2069: select sum(pab.value)
2070: from per_assignments_f paf,
2071: per_assignment_budget_values_f pab,
2072: per_assignments_f paf2
2073: where paf.assignment_id = p_assignment_id
2074: and paf.business_group_id = p_business_group_id

Line 2072: per_assignments_f paf2

2068: cursor c2 is
2069: select sum(pab.value)
2070: from per_assignments_f paf,
2071: per_assignment_budget_values_f pab,
2072: per_assignments_f paf2
2073: where paf.assignment_id = p_assignment_id
2074: and paf.business_group_id = p_business_group_id
2075: and p_effective_date
2076: between paf.effective_start_date