DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AMS_USER_STATUSES_VL

Line 2568: FROM ams_user_statuses_vl

2564: l_open_user_status_id NUMBER;
2565:
2566: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
2567: SELECT user_status_id
2568: FROM ams_user_statuses_vl
2569: WHERE system_status_type = 'OZF_CLAIM_STATUS'
2570: AND default_flag = 'Y'
2571: AND system_status_code = cv_status_code;
2572:

Line 2683: FROM ams_user_statuses_vl

2679: ---
2680:
2681: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
2682: SELECT user_status_id
2683: FROM ams_user_statuses_vl
2684: WHERE system_status_type = 'OZF_CLAIM_STATUS'
2685: AND default_flag = 'Y'
2686: AND system_status_code = cv_status_code;
2687: