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_SETTLEMENT_DOC_PVT dependencies on AMS_USER_STATUSES_VL

Line 1556: FROM ams_user_statuses_vl

1552: l_univ_curr_paid_amt NUMBER;
1553:
1554: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1555: SELECT user_status_id
1556: FROM ams_user_statuses_vl
1557: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1558: AND default_flag = 'Y'
1559: AND system_status_code = cv_status_code;
1560:

Line 1600: ams_user_statuses_vl us

1596:
1597: CURSOR csr_custom_status_id(p_claim_id IN NUMBER, p_status_code IN VARCHAR2) IS
1598: SELECT close_status_id
1599: FROM ozf_claims_all oc,
1600: ams_user_statuses_vl us
1601: WHERE oc.claim_id = p_claim_id
1602: AND oc.close_status_id = us.user_status_id
1603: AND us.system_status_type = 'OZF_CLAIM_STATUS'
1604: AND us.system_status_code = p_status_code;