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.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on DUAL

Line 56: SELECT FND_GLOBAL.CONC_REQUEST_ID INTO Conc_Prog_Id FROM DUAL;

52: PSA CP_Analytics_Bulk_Collect;
53:
54: BEGIN
55:
56: SELECT FND_GLOBAL.CONC_REQUEST_ID INTO Conc_Prog_Id FROM DUAL;
57:
58: l_check_var := PER_CHANGE_PAY_ANALYTICS_PKG.check_refresh_jobs;
59:
60: if Conc_Prog_Id = -1 and l_check_var = 1 then

Line 192: ( SELECT TRUNC(SYSDATE) EFFECTIVE_DATE FROM DUAL

188: PAY_INPUT_VALUES_F PIV ,
189: PAY_ELEMENT_TYPES_F PET ,
190: HR_LOCATIONS_ALL LOC ,
191: PAY_GRADE_RULES_F PGR ,
192: ( SELECT TRUNC(SYSDATE) EFFECTIVE_DATE FROM DUAL
193: UNION ALL
194: SELECT ADD_MONTHS(TRUNC(SYSDATE), -12) EFFECTIVE_DATE FROM DUAL
195: UNION ALL
196: SELECT ADD_MONTHS(TRUNC(SYSDATE), -24) EFFECTIVE_DATE FROM DUAL

Line 194: SELECT ADD_MONTHS(TRUNC(SYSDATE), -12) EFFECTIVE_DATE FROM DUAL

190: HR_LOCATIONS_ALL LOC ,
191: PAY_GRADE_RULES_F PGR ,
192: ( SELECT TRUNC(SYSDATE) EFFECTIVE_DATE FROM DUAL
193: UNION ALL
194: SELECT ADD_MONTHS(TRUNC(SYSDATE), -12) EFFECTIVE_DATE FROM DUAL
195: UNION ALL
196: SELECT ADD_MONTHS(TRUNC(SYSDATE), -24) EFFECTIVE_DATE FROM DUAL
197: UNION ALL
198: SELECT ADD_MONTHS(TRUNC(SYSDATE), -36) EFFECTIVE_DATE FROM DUAL

Line 196: SELECT ADD_MONTHS(TRUNC(SYSDATE), -24) EFFECTIVE_DATE FROM DUAL

192: ( SELECT TRUNC(SYSDATE) EFFECTIVE_DATE FROM DUAL
193: UNION ALL
194: SELECT ADD_MONTHS(TRUNC(SYSDATE), -12) EFFECTIVE_DATE FROM DUAL
195: UNION ALL
196: SELECT ADD_MONTHS(TRUNC(SYSDATE), -24) EFFECTIVE_DATE FROM DUAL
197: UNION ALL
198: SELECT ADD_MONTHS(TRUNC(SYSDATE), -36) EFFECTIVE_DATE FROM DUAL
199: UNION ALL
200: SELECT ADD_MONTHS(TRUNC(SYSDATE), -48) EFFECTIVE_DATE FROM DUAL ) DAY

Line 198: SELECT ADD_MONTHS(TRUNC(SYSDATE), -36) EFFECTIVE_DATE FROM DUAL

194: SELECT ADD_MONTHS(TRUNC(SYSDATE), -12) EFFECTIVE_DATE FROM DUAL
195: UNION ALL
196: SELECT ADD_MONTHS(TRUNC(SYSDATE), -24) EFFECTIVE_DATE FROM DUAL
197: UNION ALL
198: SELECT ADD_MONTHS(TRUNC(SYSDATE), -36) EFFECTIVE_DATE FROM DUAL
199: UNION ALL
200: SELECT ADD_MONTHS(TRUNC(SYSDATE), -48) EFFECTIVE_DATE FROM DUAL ) DAY
201: WHERE DAY.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE
202: AND ASG.JOB_ID IS NOT NULL

Line 200: SELECT ADD_MONTHS(TRUNC(SYSDATE), -48) EFFECTIVE_DATE FROM DUAL ) DAY

196: SELECT ADD_MONTHS(TRUNC(SYSDATE), -24) EFFECTIVE_DATE FROM DUAL
197: UNION ALL
198: SELECT ADD_MONTHS(TRUNC(SYSDATE), -36) EFFECTIVE_DATE FROM DUAL
199: UNION ALL
200: SELECT ADD_MONTHS(TRUNC(SYSDATE), -48) EFFECTIVE_DATE FROM DUAL ) DAY
201: WHERE DAY.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE
202: AND ASG.JOB_ID IS NOT NULL
203: AND SUPH.SUB_PERSON_ID = ASG.PERSON_ID
204: AND SUPH.SUB_RELATIVE_LEVEL <> 0