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.GMS_BILLING dependencies on GMS_PERSONNEL

Line 6306: GMS_PERSONNEL

6302: into
6303: X_Person_Id,
6304: X_end_date_active -- Bug fix for 863428
6305: from
6306: GMS_PERSONNEL
6307: where award_id = X_Award_Id
6308: and trunc(sysdate) between trunc(start_date_active) and trunc(end_date_active)
6309: and award_role = 'AM';
6310: EXCEPTION

Line 6318: GMS_PERSONNEL

6314: person_id
6315: into
6316: X_Person_Id
6317: from
6318: GMS_PERSONNEL
6319: where award_id = X_Award_Id
6320: and award_role = 'AM'
6321: and end_date_active IS NULL;
6322: EXCEPTION

Line 6330: GMS_PERSONNEL

6326: person_id
6327: into
6328: X_Person_Id
6329: from
6330: GMS_PERSONNEL
6331: where award_id = X_Award_Id
6332: and award_role = 'AM'
6333: and end_date_active = (select max(end_date_active)
6334: from gms_personnel

Line 6334: from gms_personnel

6330: GMS_PERSONNEL
6331: where award_id = X_Award_Id
6332: and award_role = 'AM'
6333: and end_date_active = (select max(end_date_active)
6334: from gms_personnel
6335: where
6336: award_id = X_Award_Id
6337: and award_role = 'AM');
6338: