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

Line 1917: SELECT fnd.user_name

1913: FROM ozf_claims_all
1914: WHERE claim_id = cv_claim_id;
1915:
1916: CURSOR csr_owner(cv_owner_id IN NUMBER) IS
1917: SELECT fnd.user_name
1918: FROM fnd_user fnd
1919: , ams_jtf_rs_emp_v rs
1920: WHERE rs.user_id = fnd.user_id
1921: AND rs.resource_id = cv_owner_id;

Line 1918: FROM fnd_user fnd

1914: WHERE claim_id = cv_claim_id;
1915:
1916: CURSOR csr_owner(cv_owner_id IN NUMBER) IS
1917: SELECT fnd.user_name
1918: FROM fnd_user fnd
1919: , ams_jtf_rs_emp_v rs
1920: WHERE rs.user_id = fnd.user_id
1921: AND rs.resource_id = cv_owner_id;
1922:

Line 1920: WHERE rs.user_id = fnd.user_id

1916: CURSOR csr_owner(cv_owner_id IN NUMBER) IS
1917: SELECT fnd.user_name
1918: FROM fnd_user fnd
1919: , ams_jtf_rs_emp_v rs
1920: WHERE rs.user_id = fnd.user_id
1921: AND rs.resource_id = cv_owner_id;
1922:
1923: CURSOR csr_site(cv_site_id IN NUMBER) IS
1924: SELECT location