APPS.CSD_RO_BULLETINS_PVT dependencies on CSD_BULLETINS_B

Line 891: FROM csd_bulletins_b

887: CURSOR cur_get_bulletin_info(p_bulletin_id NUMBER) IS
888: SELECT escalation_code,
889: wf_item_type,
890: wf_process_name
891: FROM csd_bulletins_b
892: WHERE bulletin_id = p_bulletin_id
893: ; --* end cur_get_bulletin_info *--
894:
895: --* get service bulletin ids for this bulletin that has been linked *--

Line 899: FROM csd_bulletins_b a, csd_bulletin_scs b

895: --* get service bulletin ids for this bulletin that has been linked *--
896: --* to an RO *--
897: CURSOR cur_get_ro_sc_ids(p_bulletin_id NUMBER) IS
898: SELECT b.service_code_id
899: FROM csd_bulletins_b a, csd_bulletin_scs b
900: WHERE a.bulletin_id = b.bulletin_id
901: AND a.bulletin_id = p_bulletin_id
902: ; --* end cur_get_ro_sc_ids *--
903: ro_sc_id_rec cur_get_ro_sc_ids%ROWTYPE;

Line 912: FROM csd_bulletins_b

908: --* returns freq_code of only if bulletin is active *--
909: --* and published *--
910: CURSOR cur_get_bulletin_freq_code(p_bulletin_id NUMBER) IS
911: SELECT frequency_code
912: FROM csd_bulletins_b
913: WHERE bulletin_id = p_bulletin_id
914: AND published_flag = FND_API.G_TRUE
915: AND sysdate BETWEEN NVL(active_from,sysdate)
916: AND NVL(active_to, sysdate)

Line 1309: from csd_bulletins_b

1305: -- CURSORS --
1306: CURSOR c_all_active_bulletins (p_bulletin_type_code varchar2)
1307: IS
1308: select bulletin_id
1309: from csd_bulletins_b
1310: where published_flag = 'T'
1311: and sysdate between nvl(active_from, sysdate-1) and nvl(active_to, sysdate+1)
1312: and bulletin_type_code = nvl(p_bulletin_type_code, bulletin_type_code);
1313: