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.HR_FULL_SYNC_MESSAGES dependencies on PER_PERIODS_OF_SERVICE

Line 21: TYPE TERMINATION_DTTYPE IS TABLE OF per_periods_of_service.final_process_date%type INDEX BY BINARY_INTEGER;

17: TYPE GRADETYPE IS TABLE OF per_all_assignments_f.grade_id%type INDEX BY BINARY_INTEGER;
18: TYPE SUPERVISOR_IDTYPE IS TABLE OF per_all_assignments_f.supervisor_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:

Line 22: TYPE LAST_DATE_WORKEDTYPE IS TABLE OF per_periods_of_service.ACCEPTED_TERMINATION_DATE%type INDEX BY BINARY_INTEGER;

18: TYPE SUPERVISOR_IDTYPE IS TABLE OF per_all_assignments_f.supervisor_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

Line 538: FROM per_periods_of_service pps

534: -- Modified for the bug 6895752 ends here
535: AND ((ppf.CURRENT_EMPLOYEE_FLAG = 'Y'
536: OR ppf.person_id in -- modified for bug6873563
537: (SELECT nvl(pps.person_id , -100)
538: FROM per_periods_of_service pps
539: WHERE pps.person_id = ppf.person_id
540: AND pps.business_group_id = ppf.business_group_id
541: and ACTUAL_TERMINATION_DATE is not null
542: ))

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(+)