DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PER_ALL_ASSIGNMENTS_F

Line 22: per_all_assignments_f assg,

18: pcak.cost_allocation_keyflex_id,
19: pcak.concatenated_segments,
20: pcaf.proportion
21: FROM
22: per_all_assignments_f assg,
23: pay_cost_allocations_f pcaf,
24: pay_cost_allocation_keyflex pcak
25: WHERE assg.assignment_id = p_assignment_id
26: AND assg.assignment_id = pcaf.assignment_id

Line 39: per_all_assignments_f assg,

35: cursor getCC_org is --this cursor will read the cc for the organizarion
36: SELECT
37: pcak.concatenated_segments
38: FROM
39: per_all_assignments_f assg,
40: hr_all_organization_units horg,
41: pay_cost_allocation_keyflex pcak
42: WHERE assg.assignment_id = p_assignment_id
43: AND assg.organization_id = horg.organization_id