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 1840: -- Fetch telephone no from per_addresses with employee_id from fnd_user

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

Line 1847: FROM fnd_user

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

Line 1863: FROM fnd_user

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

Line 1866: -- Fetch email address fnd_user

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

Line 1867: CURSOR fnd_user_csr(p_user_id VARCHAR2) IS

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

Line 1869: FROM fnd_user

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

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

1957:
1958: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1960: IF per_all_people_fnd_csr%NOTFOUND THEN
1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1963: CLOSE fnd_user_csr;
1964: END IF;
1965: CLOSE per_all_people_fnd_csr;

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

1958: OPEN per_all_people_fnd_csr(l_approversOut(i).orig_system_id);
1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1960: IF per_all_people_fnd_csr%NOTFOUND THEN
1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1963: CLOSE fnd_user_csr;
1964: END IF;
1965: CLOSE per_all_people_fnd_csr;
1966:

Line 1963: CLOSE fnd_user_csr;

1959: FETCH per_all_people_fnd_csr INTO x_workflow_table(i).email;
1960: IF per_all_people_fnd_csr%NOTFOUND THEN
1961: OPEN fnd_user_csr(l_approversOut(i).orig_system_id);
1962: FETCH fnd_user_csr INTO x_workflow_table(i).email;
1963: CLOSE fnd_user_csr;
1964: END IF;
1965: CLOSE per_all_people_fnd_csr;
1966:
1967: END IF;