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.EAM_WORKORDER_UTIL_PKG dependencies on FND_USER

Line 672: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg

668: -- added Resposibility-User active date check (furg active date check) as per bug 3464424 fix */
669: CURSOR C_RESPS IS
670: select fr.responsibility_key, fr.responsibility_id, fr.application_id,
671: fr.menu_id
672: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg
673: where fu.user_id = p_user_id
674: and furg.user_id = fu.user_id
675: and fr.responsibility_id = furg.responsibility_id
676: and fr.application_id = furg.responsibility_application_id

Line 719: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg, org_access_view oav

715:
716: CURSOR C_RESPS IS
717: select fr.responsibility_key, fr.responsibility_id, fr.application_id,
718: fr.menu_id
719: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg, org_access_view oav
720: where fu.user_id = p_user_id
721: and furg.user_id = fu.user_id
722: and fr.responsibility_id = furg.responsibility_id
723: and fr.application_id = furg.responsibility_application_id

Line 1839: -- Fetch telephone no from per_addresses with employee_id from fnd_user

1835: WHERE person_id = p_person_id
1836: AND sysdate BETWEEN date_from AND date_to
1837: AND primary_flag = 'Y';
1838:
1839: -- Fetch telephone no from per_addresses with employee_id from fnd_user
1840: CURSOR per_addresses_fnd_csr(p_user_id NUMBER) IS
1841: SELECT telephone_number_1
1842: FROM per_addresses
1843: WHERE sysdate BETWEEN date_from AND date_to

Line 1846: FROM fnd_user

1842: FROM per_addresses
1843: WHERE sysdate BETWEEN date_from AND date_to
1844: AND primary_flag = 'Y'
1845: AND person_id = (SELECT employee_id
1846: FROM fnd_user
1847: WHERE user_id = p_user_id);
1848:
1849: -- Fetch email address per_all_people_f
1850: CURSOR per_all_people_csr(p_person_id NUMBER) IS

Line 1862: FROM fnd_user

1858: SELECT email_address
1859: FROM per_all_people_f
1860: WHERE sysdate between effective_start_date AND effective_end_date
1861: AND person_id = (SELECT employee_id
1862: FROM fnd_user
1863: WHERE user_id = p_user_id);
1864:
1865: -- Fetch email address fnd_user
1866: CURSOR fnd_user_csr(p_user_id VARCHAR2) IS

Line 1865: -- Fetch email address fnd_user

1861: AND person_id = (SELECT employee_id
1862: FROM fnd_user
1863: WHERE user_id = p_user_id);
1864:
1865: -- Fetch email address fnd_user
1866: CURSOR fnd_user_csr(p_user_id VARCHAR2) IS
1867: SELECT email_address
1868: FROM fnd_user
1869: WHERE user_id = p_user_id;

Line 1866: CURSOR fnd_user_csr(p_user_id VARCHAR2) IS

1862: FROM fnd_user
1863: WHERE user_id = p_user_id);
1864:
1865: -- Fetch email address fnd_user
1866: CURSOR fnd_user_csr(p_user_id VARCHAR2) IS
1867: SELECT email_address
1868: FROM fnd_user
1869: WHERE user_id = p_user_id;
1870:

Line 1868: FROM fnd_user

1864:
1865: -- Fetch email address fnd_user
1866: CURSOR fnd_user_csr(p_user_id VARCHAR2) IS
1867: SELECT email_address
1868: FROM fnd_user
1869: WHERE user_id = p_user_id;
1870:
1871: l_transaction_type VARCHAR2(250);
1872:

Line 1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);

1908:
1909: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1910: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1911: IF per_all_people_fnd_csr%NOTFOUND THEN
1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1914: CLOSE fnd_user_csr;
1915: END IF;
1916: CLOSE per_all_people_fnd_csr;

Line 1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;

1909: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1910: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1911: IF per_all_people_fnd_csr%NOTFOUND THEN
1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1914: CLOSE fnd_user_csr;
1915: END IF;
1916: CLOSE per_all_people_fnd_csr;
1917:

Line 1914: CLOSE fnd_user_csr;

1910: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1911: IF per_all_people_fnd_csr%NOTFOUND THEN
1912: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1913: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1914: CLOSE fnd_user_csr;
1915: END IF;
1916: CLOSE per_all_people_fnd_csr;
1917:
1918: END IF;