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_PO_INFO dependencies on FND_DATE

Line 314: ||' AND fnd_date.canonical_to_date('''

310: ||' ,paaf.assignment_id '
311: ||' FROM per_all_assignments_f paaf '
312: ||' WHERE paaf.po_line_id IS NOT NULL '
313: ||' AND paaf.po_line_id = '||p_po_line_id
314: ||' AND fnd_date.canonical_to_date('''
315: || fnd_date.date_to_canonical(l_effective_date)||''')'
316: ||' BETWEEN paaf.effective_start_date '
317: ||' AND paaf.effective_end_date ';
318:

Line 315: || fnd_date.date_to_canonical(l_effective_date)||''')'

311: ||' FROM per_all_assignments_f paaf '
312: ||' WHERE paaf.po_line_id IS NOT NULL '
313: ||' AND paaf.po_line_id = '||p_po_line_id
314: ||' AND fnd_date.canonical_to_date('''
315: || fnd_date.date_to_canonical(l_effective_date)||''')'
316: ||' BETWEEN paaf.effective_start_date '
317: ||' AND paaf.effective_end_date ';
318:
319: EXECUTE IMMEDIATE l_sql INTO p_person_id, p_assignment_id;

Line 699: ||' AND fnd_date.canonical_to_date('''

695: ||' ,paaf.assignment_id '
696: ||' FROM per_all_assignments_f paaf '
697: ||' WHERE paaf.vendor_site_id IS NOT NULL '
698: ||' AND paaf.vendor_site_id = '||p_vendor_site_id
699: ||' AND fnd_date.canonical_to_date('''
700: || fnd_date.date_to_canonical(l_effective_date)||''')'
701: ||' BETWEEN paaf.effective_start_date '
702: ||' AND paaf.effective_end_date ';
703:

Line 700: || fnd_date.date_to_canonical(l_effective_date)||''')'

696: ||' FROM per_all_assignments_f paaf '
697: ||' WHERE paaf.vendor_site_id IS NOT NULL '
698: ||' AND paaf.vendor_site_id = '||p_vendor_site_id
699: ||' AND fnd_date.canonical_to_date('''
700: || fnd_date.date_to_canonical(l_effective_date)||''')'
701: ||' BETWEEN paaf.effective_start_date '
702: ||' AND paaf.effective_end_date ';
703:
704: EXECUTE IMMEDIATE l_sql INTO p_person_id, p_assignment_id;

Line 1126: ||' AND fnd_date.canonical_to_date('''

1122: ||' ,paaf.vendor_site_id '
1123: ||' FROM per_all_assignments_f paaf '
1124: ||' WHERE paaf.person_id = '||p_person_id
1125: ||' AND paaf.primary_flag = ''Y'''
1126: ||' AND fnd_date.canonical_to_date('''
1127: || fnd_date.date_to_canonical(p_effective_date)||''')'
1128: ||' BETWEEN paaf.effective_start_date '
1129: ||' AND paaf.effective_end_date '
1130: ||' AND (paaf.vendor_id IS NOT NULL OR '

Line 1127: || fnd_date.date_to_canonical(p_effective_date)||''')'

1123: ||' FROM per_all_assignments_f paaf '
1124: ||' WHERE paaf.person_id = '||p_person_id
1125: ||' AND paaf.primary_flag = ''Y'''
1126: ||' AND fnd_date.canonical_to_date('''
1127: || fnd_date.date_to_canonical(p_effective_date)||''')'
1128: ||' BETWEEN paaf.effective_start_date '
1129: ||' AND paaf.effective_end_date '
1130: ||' AND (paaf.vendor_id IS NOT NULL OR '
1131: ||' paaf.vendor_site_id IS NOT NULL) ';

Line 1187: ||' AND fnd_date.canonical_to_date('''

1183: ' SELECT paaf.vendor_id '
1184: ||' ,paaf.vendor_site_id '
1185: ||' FROM per_all_assignments_f paaf '
1186: ||' WHERE paaf.assignment_id = '||p_assignment_id
1187: ||' AND fnd_date.canonical_to_date('''
1188: || fnd_date.date_to_canonical(p_effective_date)||''')'
1189: ||' BETWEEN paaf.effective_start_date '
1190: ||' AND paaf.effective_end_date '
1191: ||' AND (paaf.vendor_id IS NOT NULL OR '

Line 1188: || fnd_date.date_to_canonical(p_effective_date)||''')'

1184: ||' ,paaf.vendor_site_id '
1185: ||' FROM per_all_assignments_f paaf '
1186: ||' WHERE paaf.assignment_id = '||p_assignment_id
1187: ||' AND fnd_date.canonical_to_date('''
1188: || fnd_date.date_to_canonical(p_effective_date)||''')'
1189: ||' BETWEEN paaf.effective_start_date '
1190: ||' AND paaf.effective_end_date '
1191: ||' AND (paaf.vendor_id IS NOT NULL OR '
1192: ||' paaf.vendor_site_id IS NOT NULL) ';

Line 1250: ||' AND fnd_date.canonical_to_date('''

1246: ||' ,paaf.po_line_id '
1247: ||' FROM per_all_assignments_f paaf '
1248: ||' WHERE paaf.person_id = '||p_person_id
1249: ||' AND paaf.primary_flag = ''Y'''
1250: ||' AND fnd_date.canonical_to_date('''
1251: || fnd_date.date_to_canonical(p_effective_date)||''')'
1252: ||' BETWEEN paaf.effective_start_date '
1253: ||' AND paaf.effective_end_date '
1254: ||' AND (paaf.po_header_id IS NOT NULL OR '

Line 1251: || fnd_date.date_to_canonical(p_effective_date)||''')'

1247: ||' FROM per_all_assignments_f paaf '
1248: ||' WHERE paaf.person_id = '||p_person_id
1249: ||' AND paaf.primary_flag = ''Y'''
1250: ||' AND fnd_date.canonical_to_date('''
1251: || fnd_date.date_to_canonical(p_effective_date)||''')'
1252: ||' BETWEEN paaf.effective_start_date '
1253: ||' AND paaf.effective_end_date '
1254: ||' AND (paaf.po_header_id IS NOT NULL OR '
1255: ||' paaf.po_line_id IS NOT NULL) ';

Line 1311: ||' AND fnd_date.canonical_to_date('''

1307: ' SELECT paaf.po_header_id '
1308: ||' ,paaf.po_line_id '
1309: ||' FROM per_all_assignments_f paaf '
1310: ||' WHERE paaf.assignment_id = '||p_assignment_id
1311: ||' AND fnd_date.canonical_to_date('''
1312: || fnd_date.date_to_canonical(p_effective_date)||''')'
1313: ||' BETWEEN paaf.effective_start_date '
1314: ||' AND paaf.effective_end_date '
1315: ||' AND (paaf.po_header_id IS NOT NULL OR '

Line 1312: || fnd_date.date_to_canonical(p_effective_date)||''')'

1308: ||' ,paaf.po_line_id '
1309: ||' FROM per_all_assignments_f paaf '
1310: ||' WHERE paaf.assignment_id = '||p_assignment_id
1311: ||' AND fnd_date.canonical_to_date('''
1312: || fnd_date.date_to_canonical(p_effective_date)||''')'
1313: ||' BETWEEN paaf.effective_start_date '
1314: ||' AND paaf.effective_end_date '
1315: ||' AND (paaf.po_header_id IS NOT NULL OR '
1316: ||' paaf.po_line_id IS NOT NULL) ';