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.PSP_GENERAL dependencies on FND_DATE

Line 1125: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR

1121: from gms_awards_all --Bug 6908158
1122: where award_id = p_award_id;
1123:
1124: IF (p_start_date NOT BETWEEN x_award_start_date AND
1125: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
1126: (NVL(p_end_date, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN x_award_start_date AND
1127: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
1128: return(FALSE);
1129: ELSE

Line 1126: (NVL(p_end_date, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN x_award_start_date AND

1122: where award_id = p_award_id;
1123:
1124: IF (p_start_date NOT BETWEEN x_award_start_date AND
1125: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
1126: (NVL(p_end_date, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN x_award_start_date AND
1127: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
1128: return(FALSE);
1129: ELSE
1130: return(TRUE);

Line 1127: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN

1123:
1124: IF (p_start_date NOT BETWEEN x_award_start_date AND
1125: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
1126: (NVL(p_end_date, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN x_award_start_date AND
1127: NVL(x_award_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
1128: return(FALSE);
1129: ELSE
1130: return(TRUE);
1131: END IF;