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.PAY_DYT_DURATION_SUMMARY_PKG dependencies on PER_ASSIGNMENTS_F

Line 76: FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN

72: L_DATE_START := P_OLD_DATE_START;
73: --
74: SELECT BUSINESS_GROUP_ID
75: INTO L_BUSINESS_GROUP_ID
76: FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN
77: EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
78: --
79: SELECT LEGISLATION_CODE
80: INTO L_LEGISLATION_CODE

Line 173: FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND

169: L_DATE_START := P_NEW_DATE_START;
170: --
171: SELECT BUSINESS_GROUP_ID
172: INTO L_BUSINESS_GROUP_ID
173: FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND
174: L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
175: --
176: SELECT LEGISLATION_CODE
177: INTO L_LEGISLATION_CODE

Line 279: FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

275:
276: --
277: SELECT BUSINESS_GROUP_ID
278: INTO L_BUSINESS_GROUP_ID
279: FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = L_ASSIGNMENT_ID AND L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
280: --
281: SELECT LEGISLATION_CODE
282: INTO L_LEGISLATION_CODE
283: