DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on AMS_USER_STATUSES_VL

Line 1552: FROM ams_user_statuses_vl

1548: WHERE claim_id = cv_claim_id;
1549:
1550: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1551: SELECT user_status_id
1552: FROM ams_user_statuses_vl
1553: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1554: AND system_status_code = cv_status_code;
1555:
1556: l_user_status_id NUMBER;

Line 1736: FROM ams_user_statuses_vl

1732: WHERE claim_id = cv_claim_id;
1733:
1734: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1735: SELECT user_status_id
1736: FROM ams_user_statuses_vl
1737: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1738: AND system_status_code = cv_status_code;
1739:
1740: l_claim_id NUMBER;