DBA Data[Home] [Help]

APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on AMS_USER_STATUSES_VL

Line 965: FROM ams_user_statuses_vl

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

Line 1270: FROM ams_user_statuses_vl

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