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 309: ||' AND fnd_date.canonical_to_date('''

305: ||' ,paaf.assignment_id '
306: ||' FROM per_all_assignments_f paaf '
307: ||' WHERE paaf.po_line_id IS NOT NULL '
308: ||' AND paaf.po_line_id = '||p_po_line_id
309: ||' AND fnd_date.canonical_to_date('''
310: || fnd_date.date_to_canonical(l_effective_date)||''')'
311: ||' BETWEEN paaf.effective_start_date '
312: ||' AND paaf.effective_end_date ';
313:

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

306: ||' FROM per_all_assignments_f paaf '
307: ||' WHERE paaf.po_line_id IS NOT NULL '
308: ||' AND paaf.po_line_id = '||p_po_line_id
309: ||' AND fnd_date.canonical_to_date('''
310: || fnd_date.date_to_canonical(l_effective_date)||''')'
311: ||' BETWEEN paaf.effective_start_date '
312: ||' AND paaf.effective_end_date ';
313:
314: EXECUTE IMMEDIATE l_sql INTO p_person_id, p_assignment_id;

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

690: ||' ,paaf.assignment_id '
691: ||' FROM per_all_assignments_f paaf '
692: ||' WHERE paaf.vendor_site_id IS NOT NULL '
693: ||' AND paaf.vendor_site_id = '||p_vendor_site_id
694: ||' AND fnd_date.canonical_to_date('''
695: || fnd_date.date_to_canonical(l_effective_date)||''')'
696: ||' BETWEEN paaf.effective_start_date '
697: ||' AND paaf.effective_end_date ';
698:

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

691: ||' FROM per_all_assignments_f paaf '
692: ||' WHERE paaf.vendor_site_id IS NOT NULL '
693: ||' AND paaf.vendor_site_id = '||p_vendor_site_id
694: ||' AND fnd_date.canonical_to_date('''
695: || fnd_date.date_to_canonical(l_effective_date)||''')'
696: ||' BETWEEN paaf.effective_start_date '
697: ||' AND paaf.effective_end_date ';
698:
699: EXECUTE IMMEDIATE l_sql INTO p_person_id, p_assignment_id;

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

1117: ||' ,paaf.vendor_site_id '
1118: ||' FROM per_all_assignments_f paaf '
1119: ||' WHERE paaf.person_id = '||p_person_id
1120: ||' AND paaf.primary_flag = ''Y'''
1121: ||' AND fnd_date.canonical_to_date('''
1122: || fnd_date.date_to_canonical(p_effective_date)||''')'
1123: ||' BETWEEN paaf.effective_start_date '
1124: ||' AND paaf.effective_end_date '
1125: ||' AND (paaf.vendor_id IS NOT NULL OR '

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

1118: ||' FROM per_all_assignments_f paaf '
1119: ||' WHERE paaf.person_id = '||p_person_id
1120: ||' AND paaf.primary_flag = ''Y'''
1121: ||' AND fnd_date.canonical_to_date('''
1122: || fnd_date.date_to_canonical(p_effective_date)||''')'
1123: ||' BETWEEN paaf.effective_start_date '
1124: ||' AND paaf.effective_end_date '
1125: ||' AND (paaf.vendor_id IS NOT NULL OR '
1126: ||' paaf.vendor_site_id IS NOT NULL) ';

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

1178: ' SELECT paaf.vendor_id '
1179: ||' ,paaf.vendor_site_id '
1180: ||' FROM per_all_assignments_f paaf '
1181: ||' WHERE paaf.assignment_id = '||p_assignment_id
1182: ||' AND fnd_date.canonical_to_date('''
1183: || fnd_date.date_to_canonical(p_effective_date)||''')'
1184: ||' BETWEEN paaf.effective_start_date '
1185: ||' AND paaf.effective_end_date '
1186: ||' AND (paaf.vendor_id IS NOT NULL OR '

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

1179: ||' ,paaf.vendor_site_id '
1180: ||' FROM per_all_assignments_f paaf '
1181: ||' WHERE paaf.assignment_id = '||p_assignment_id
1182: ||' AND fnd_date.canonical_to_date('''
1183: || fnd_date.date_to_canonical(p_effective_date)||''')'
1184: ||' BETWEEN paaf.effective_start_date '
1185: ||' AND paaf.effective_end_date '
1186: ||' AND (paaf.vendor_id IS NOT NULL OR '
1187: ||' paaf.vendor_site_id IS NOT NULL) ';

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

1241: ||' ,paaf.po_line_id '
1242: ||' FROM per_all_assignments_f paaf '
1243: ||' WHERE paaf.person_id = '||p_person_id
1244: ||' AND paaf.primary_flag = ''Y'''
1245: ||' AND fnd_date.canonical_to_date('''
1246: || fnd_date.date_to_canonical(p_effective_date)||''')'
1247: ||' BETWEEN paaf.effective_start_date '
1248: ||' AND paaf.effective_end_date '
1249: ||' AND (paaf.po_header_id IS NOT NULL OR '

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

1242: ||' FROM per_all_assignments_f paaf '
1243: ||' WHERE paaf.person_id = '||p_person_id
1244: ||' AND paaf.primary_flag = ''Y'''
1245: ||' AND fnd_date.canonical_to_date('''
1246: || fnd_date.date_to_canonical(p_effective_date)||''')'
1247: ||' BETWEEN paaf.effective_start_date '
1248: ||' AND paaf.effective_end_date '
1249: ||' AND (paaf.po_header_id IS NOT NULL OR '
1250: ||' paaf.po_line_id IS NOT NULL) ';

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

1302: ' SELECT paaf.po_header_id '
1303: ||' ,paaf.po_line_id '
1304: ||' FROM per_all_assignments_f paaf '
1305: ||' WHERE paaf.assignment_id = '||p_assignment_id
1306: ||' AND fnd_date.canonical_to_date('''
1307: || fnd_date.date_to_canonical(p_effective_date)||''')'
1308: ||' BETWEEN paaf.effective_start_date '
1309: ||' AND paaf.effective_end_date '
1310: ||' AND (paaf.po_header_id IS NOT NULL OR '

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

1303: ||' ,paaf.po_line_id '
1304: ||' FROM per_all_assignments_f paaf '
1305: ||' WHERE paaf.assignment_id = '||p_assignment_id
1306: ||' AND fnd_date.canonical_to_date('''
1307: || fnd_date.date_to_canonical(p_effective_date)||''')'
1308: ||' BETWEEN paaf.effective_start_date '
1309: ||' AND paaf.effective_end_date '
1310: ||' AND (paaf.po_header_id IS NOT NULL OR '
1311: ||' paaf.po_line_id IS NOT NULL) ';