APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 23: TYPE STEPTYPE IS TABLE OF PER_SPINAL_POINT_PLACEMENTS_F.STEP_ID%type INDEX BY BINARY_INTEGER;

19: TYPE ASGN_START_DTTYPE IS TABLE OF per_all_assignments_f.EFFECTIVE_START_DATE%type INDEX BY BINARY_INTEGER;
20: TYPE ASGN_END_DTTYPE IS TABLE OF per_all_assignments_f.EFFECTIVE_END_DATE%type INDEX BY BINARY_INTEGER;
21: TYPE TERMINATION_DTTYPE IS TABLE OF per_periods_of_service.final_process_date%type INDEX BY BINARY_INTEGER;
22: TYPE LAST_DATE_WORKEDTYPE IS TABLE OF per_periods_of_service.ACCEPTED_TERMINATION_DATE%type INDEX BY BINARY_INTEGER;
23: TYPE STEPTYPE IS TABLE OF PER_SPINAL_POINT_PLACEMENTS_F.STEP_ID%type INDEX BY BINARY_INTEGER;
24: TYPE workforce IS REF CURSOR;
25:
26: TYPE WorkForceTblType IS RECORD
27: (

Line 769: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf

765: nvl(pas.EFFECTIVE_END_DATE,sysdate) EFFECTIVE_END_DATE,
766: nvl(psf.step_id,0) Step_id
767: ,pos.final_process_date,pos.ACCEPTED_TERMINATION_DATE
768: FROM per_all_people_f ppf,per_all_assignments_f pas,
769: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf
770: WHERE pas.primary_flag='Y'
771: AND pos.person_id=pas.person_id
772: AND ppf.person_id = pos.person_id
773: AND pas.business_group_id = psf.business_group_id(+)