DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on PER_ASSIGNMENTS_F

Line 1718: FROM per_assignments_f a

1714: )
1715: IS
1716: CURSOR c IS
1717: SELECT a.assignment_id
1718: FROM per_assignments_f a
1719: , jtf_rs_resource_extns r
1720: WHERE r.resource_id = p_emp_resource_id
1721: AND a.person_id = r.source_id
1722: AND a.primary_flag = 'Y'

Line 1743: FROM per_assignments_f a

1739: )
1740: IS
1741: CURSOR c IS
1742: SELECT r.resource_id
1743: FROM per_assignments_f a
1744: , jtf_rs_resource_extns r
1745: WHERE a.assignment_id = p_per_assignment_id
1746: AND r.source_id = a.person_id
1747: AND r.category = 'EMPLOYEE';