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_DELTA_SYNC_MESSAGES dependencies on PER_PERIODS_OF_SERVICE

Line 986: FROM per_periods_of_service pps

982: -- Modified for the bug 6895752 ends here
983: AND ((ppf.CURRENT_EMPLOYEE_FLAG = 'Y'
984: OR ppf.person_id in -- modified for bug6873563
985: (SELECT nvl(pps.person_id , -100)
986: FROM per_periods_of_service pps
987: WHERE pps.person_id = ppf.person_id
988: AND pps.business_group_id = ppf.business_group_id
989: AND pps.last_update_date > P_SYNC_DATE
990: and ACTUAL_TERMINATION_DATE is not null

Line 1101: FROM per_periods_of_service pps

1097: -- Modified for the bug 6895752 ends here
1098: AND ((ppf.CURRENT_EMPLOYEE_FLAG = 'Y'
1099: OR ppf.person_id =
1100: (SELECT nvl(pps.person_id , -100)
1101: FROM per_periods_of_service pps
1102: WHERE pps.person_id = ppf.person_id
1103: AND pps.business_group_id = ppf.business_group_id
1104: AND pps.business_group_id = p_business_group_id
1105: --AND pps.last_update_date > P_SYNC_DATE

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

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

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

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

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