DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_USER_STATUSES_B

Line 1725: FROM ams_user_statuses_b

1721: AND end_date_time <= SYSDATE ;
1722:
1723: CURSOR c_status(l_status_code VARCHAR2) IS
1724: SELECT user_status_id
1725: FROM ams_user_statuses_b
1726: WHERE system_status_type = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
1727: AND system_status_code = l_status_code
1728: AND default_flag = 'Y'
1729: AND enabled_flag = 'Y' ;

Line 2984: FROM ams_user_statuses_b

2980: -- dbiswas added the following cursor for bug 2852078
2981: CURSOR c_is_default_flag_on (p_user_status_id NUMBER)
2982: IS
2983: SELECT default_flag
2984: FROM ams_user_statuses_b
2985: WHERE user_status_id = p_user_status_id;
2986:
2987: BEGIN
2988: