DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AMS_USER_STATUSES_VL

Line 2589: FROM ams_user_statuses_vl

2585: l_open_user_status_id NUMBER;
2586:
2587: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
2588: SELECT user_status_id
2589: FROM ams_user_statuses_vl
2590: WHERE system_status_type = 'OZF_CLAIM_STATUS'
2591: AND default_flag = 'Y'
2592: AND system_status_code = cv_status_code;
2593:

Line 2704: FROM ams_user_statuses_vl

2700: ---
2701:
2702: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
2703: SELECT user_status_id
2704: FROM ams_user_statuses_vl
2705: WHERE system_status_type = 'OZF_CLAIM_STATUS'
2706: AND default_flag = 'Y'
2707: AND system_status_code = cv_status_code;
2708: