DBA Data[Home] [Help]

APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on AMS_USER_STATUSES_VL

Line 963: FROM ams_user_statuses_vl

959: l_return_status VARCHAR2(1);
960:
961: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
962: SELECT user_status_id
963: FROM ams_user_statuses_vl
964: WHERE system_status_type = 'OZF_CLAIM_STATUS'
965: AND default_flag = 'Y'
966: AND system_status_code = cv_status_code;
967:

Line 1268: FROM ams_user_statuses_vl

1264: WHERE set_of_books_id = cv_set_of_books_id;
1265:
1266: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1267: SELECT user_status_id
1268: FROM ams_user_statuses_vl
1269: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1270: AND default_flag = 'Y'
1271: AND system_status_code = cv_status_code;
1272: