APPS.HR_DELTA_SYNC_MESSAGES dependencies on PER_SPINAL_POINT_PLACEMENTS_F

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

1388: TYPE ASGN_START_DTTYPE IS TABLE OF per_all_assignments_f.EFFECTIVE_START_DATE%type INDEX BY BINARY_INTEGER;
1389: TYPE ASGN_END_DTTYPE IS TABLE OF per_all_assignments_f.EFFECTIVE_END_DATE%type INDEX BY BINARY_INTEGER;
1390: TYPE TERMINATION_DTTYPE IS TABLE OF per_periods_of_service.final_process_date%type INDEX BY BINARY_INTEGER;
1391: TYPE LAST_DATE_WORKEDTYPE IS TABLE OF per_periods_of_service.ACCEPTED_TERMINATION_DATE%type INDEX BY BINARY_INTEGER;
1392: TYPE STEPTYPE IS TABLE OF PER_SPINAL_POINT_PLACEMENTS_F.STEP_ID%type INDEX BY BINARY_INTEGER;
1393: TYPE LSTUPDDTTYPE IS TABLE OF per_all_assignments_f.last_update_date%type INDEX BY BINARY_INTEGER;
1394: TYPE workforce IS REF CURSOR;
1395:
1396: TYPE WorkForceTblType IS RECORD

Line 1520: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf

1516: nvl(pas.EFFECTIVE_END_DATE,sysdate) EFFECTIVE_END_DATE,
1517: nvl(psf.step_id,0) Step_id
1518: ,pos.final_process_date,pos.ACCEPTED_TERMINATION_DATE,pas.last_update_date
1519: FROM per_all_people_f ppf,per_all_assignments_f pas,
1520: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf
1521: WHERE pas.primary_flag='Y'
1522: AND pos.person_id=pas.person_id
1523: AND ppf.person_id = pos.person_id
1524: AND pas.business_group_id = psf.business_group_id(+)

Line 1659: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf

1655: nvl(pas.EFFECTIVE_END_DATE,sysdate) EFFECTIVE_END_DATE,
1656: nvl(psf.step_id,0) Step_id
1657: ,pos.final_process_date,pos.ACCEPTED_TERMINATION_DATE,pas.last_update_date
1658: FROM per_all_people_f ppf,per_all_assignments_f pas,
1659: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf
1660: WHERE pas.primary_flag='Y'
1661: AND pos.person_id=pas.person_id
1662: AND ppf.person_id = pos.person_id
1663: AND pas.business_group_id = psf.business_group_id(+)